This media is not supported in your browser
VIEW IN TELEGRAM
Freelancer code
SELECT
DATE_FORMAT(DATE, '%Y-%m') AS month_year,
source,
SUM(total_number) AS total_number
FROM (
SELECT
DATE(created_at) AS DATE,
'jobs' AS source,
COUNT(*) AS total_number
FROM JobPosts
WHERE YEAR(created_at) = 2022
GROUP BY DATE(created_at)
UNION ALL
SELECT
DATE(created_at) AS DATE,
'Freelancers' AS source,
COUNT(*) AS total_number
FROM Freelancers
WHERE YEAR(created_at) = 2022
GROUP BY DATE(created_at)
) AS t
GROUP BY
DATE_FORMAT(DATE, '%Y-%m'),
source
ORDER BY
DATE_FORMAT(DATE, '%Y-%m'),
source;
Freelancer code 👆👆👆👆
Share @coding_000❤️
SELECT
DATE_FORMAT(DATE, '%Y-%m') AS month_year,
source,
SUM(total_number) AS total_number
FROM (
SELECT
DATE(created_at) AS DATE,
'jobs' AS source,
COUNT(*) AS total_number
FROM JobPosts
WHERE YEAR(created_at) = 2022
GROUP BY DATE(created_at)
UNION ALL
SELECT
DATE(created_at) AS DATE,
'Freelancers' AS source,
COUNT(*) AS total_number
FROM Freelancers
WHERE YEAR(created_at) = 2022
GROUP BY DATE(created_at)
) AS t
GROUP BY
DATE_FORMAT(DATE, '%Y-%m'),
source
ORDER BY
DATE_FORMAT(DATE, '%Y-%m'),
source;
Freelancer code 👆👆👆👆
Share @coding_000❤️
❤2🔥1
🥰1
SELECT
DATE_FORMAT(dt, '%Y-%m') AS month_year,
'Jobs' AS source,
COUNT(*) AS total_number
FROM jobs
WHERE YEAR(dt) = 2022
GROUP BY month_year
UNION ALL
-- For freelancer registrations
SELECT
DATE_FORMAT(dt, '%Y-%m') AS month_year,
'Freelancers' AS source,
COUNT(*) AS total_number
FROM freelancers
WHERE YEAR(dt) = 2022
GROUP BY month_year
ORDER BY month_year, source;
leading freelancer code ✅
DATE_FORMAT(dt, '%Y-%m') AS month_year,
'Jobs' AS source,
COUNT(*) AS total_number
FROM jobs
WHERE YEAR(dt) = 2022
GROUP BY month_year
UNION ALL
-- For freelancer registrations
SELECT
DATE_FORMAT(dt, '%Y-%m') AS month_year,
'Freelancers' AS source,
COUNT(*) AS total_number
FROM freelancers
WHERE YEAR(dt) = 2022
GROUP BY month_year
ORDER BY month_year, source;
leading freelancer code ✅
🔥2
❤2👍1🔥1🥰1
Contact @ILOVEU_143 for NOV 6th COGNIZANT CSD slot 😊
Note it's paid✅
Proofs👇👇
https://t.me/Coding_000/5572
https://t.me/Coding_000/5570
https://t.me/Coding_000/5569
100% clearance guarantee 🔥🔥
Share my channel with your friends and college groups🥳
Trust us Expect us ❤️ @CODING_000✅
Note it's paid✅
Proofs👇👇
https://t.me/Coding_000/5572
https://t.me/Coding_000/5570
https://t.me/Coding_000/5569
100% clearance guarantee 🔥🔥
Share my channel with your friends and college groups🥳
Trust us Expect us ❤️ @CODING_000✅
👍2