Beginner SQL Course⚡️ #29: Calculate a Percent Case Study

Hi BDEs! ⚡️ Hands-on material below ⬇️
🔗 📈Written material, Datasets, and Data Model for this lesson: jessramosdata....
This is lesson 29 (Calculate a Percent Case Study) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end.
If you like this beginner course, you’ll LOVE the Big SQL Energy intermediate course which will have you job ready and acing your interviews for your dream data analyst job. We will go into more advanced skills by solving real business problems that I’ve solved on the job as a Senior Data Analyst in tech. At the end, I’ll help you build 2 projects that are exact replicas that I’ve solved in the real world, and then I’ll show you how to add them to your data analytics portfolio.
🔗 Intermediate Course: bigdataenergyc...
🤳🏼 SOCIALS
📫 Newsletter: jessramosdata....
📸 Instagram: @JessRamosData
💙 LinkedIn: Jess Ramos, MSBA
🎬 TikTok: @JessRamosData
💌 Brand Partnerships: [e-mail]

[@nilaygokdemir4553]

sum(case when product_name='Laptop' then 1 else 0 end)::int as laptop_binary,
sum(case when product_name='Monitor' then 1 else 0 end)::int as monitor_binary,
sum(case when product_name='Mouse' then 1 else 0 end)::int as mouse_binary,
sum(case when product_name='Webcam' then 1 else 0 end)::int as webcam_binary,
sum(case when product_name='Keyboard' then 1 else 0 end)::int as keyboard_binary,