Coding | EXAMS | IBM ACCENTURE | VIRTUSA | IBM | AMAZON | TCS | EPAM | WILEY EDGE | TECH MAHINDRA | JPMORGAN | HCL | WIPRO
3.37K subscribers
1.13K photos
3 videos
17 files
373 links
Main channel https://t.me/Coding_000
Contact Admin 👉 @ILOVEU_143 for booking your exam slots
Web- https://coding000.github.io/Projects/
💯% clearance in any placement exams
OffCampus -https://t.me/Offcampus_000
Discussion- https://t.me/exams_discussion
Download 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❤️
2🔥1
Check above 👆👆 If ur unable to find the questions answer
Share @coding_000❤️
send in comment 👇👇
🥰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
🔥2
Guys pls wait i will try to send...asap maximum answers....❤️

kerp sharing @coding_000
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
👍2
ACCENTURE 👇👇

Only coding slots available

Help Available
Msg: @ILOVEU_143

Note: It's Paid 💰💰
Test Clearance Guaranteed
Your Job Our Responsibility 😊
👍2🥰1