Asosiy matnga o'tish

138. Manba bo'yicha konversiya

O'rtacha

Har bir trafik manbasi uchun konversiya foizini hisoblang — bu ikkita

agregatning nisbati:

conversion_pct = 100 * (konversiyalar soni) / (tashriflar soni)

conversion_pct 2 xonagacha yaxlitlansin. Butun sonlarni bo'lishda

natija butunga aylanib qolmasligiga e'tibor bering.

Bitta ham konversiyasi bo'lmagan manba uchun 0.00 chiqsin.

Ustunlar: source, visits, conversions, conversion_pct.

Saralash: conversion_pct kamayish, keyin source alifbo.

visits: id INT PK, source VARCHAR, converted BOOLEAN

Namuna ma'lumotlar

sample
visits
idINTsourceVARCHAR(30)convertedBOOLEAN
9telegramtrue
10telegramtrue
12telegramfalse
13instagramfalse
14instagramfalse
Kutilgan natija
sourcevisitsconversionsconversion_pct
telegram3266.67
instagram200
sample-full
visits
idINTsourceVARCHAR(30)convertedBOOLEAN
1googletrue
2googlefalse
3googlefalse
4googletrue
5googlefalse
6googlefalse
7googlefalse
8googlefalse
9telegramtrue
10telegramtrue
11telegramtrue
12telegramfalse
13instagramfalse
14instagramfalse
15instagramfalse
16directtrue
17directfalse
18facebooktrue
19facebooktrue
20facebookfalse
21facebookfalse
Kutilgan natija
sourcevisitsconversionsconversion_pct
telegram4375
direct2150
facebook4250
google8225
instagram300
sample-extra
visits
idINTsourceVARCHAR(30)convertedBOOLEAN
1directtrue
2telegramtrue
3googlefalse
4telegramtrue
Kutilgan natija
sourcevisitsconversionsconversion_pct
direct11100
telegram22100
google100

O'xshash masalalar

Konsol

Natijani ko'rish uchun so'rovni ishga tushiring.