sawo11 님의 블로그

This is the same question as problem #3 in the SQL Chapter of Ace the Data Science Interview!Assume you're given the table on user viewership categorised by device type where the three types are laptop, tablet, and phone.Write a query that calculates the total viewership for laptops and mobile devices where mobile is defined as the sum of tablet and phone viewership. Output the total viewership ..

Tesla is investigating production bottlenecks and they need your help to extract the relevant data. Write a query to determine which parts have begun the assembly process but are not yet finished.Assumptions:parts_assembly table contains all parts currently in production, each at varying stages of the assembly process.An unfinished part is one that lacks a finish_date.This question is straightfo..

Assume you're given two tables containing data about Facebook Pages and their respective likes (as in "Like a Facebook Page").Write a query to return the IDs of the Facebook pages that have zero likes. The output should be sorted in ascending order based on the page IDs.pages Table: ColumnNameTypepage_namevarcharpage_idintegerpages Example Input:page_idpage_name20001SQL Solutions20045Brain Exerc..

Given a table of candidates and their skills, you're tasked with finding the candidates best suited for an open Data Science job. You want to find candidates who are proficient in Python, Tableau, and PostgreSQL.Write a query to list the candidates who possess all of the required skills for the job. Sort the output by candidate ID in ascending order. Assumption:There are no duplicates in the can..

Assume you're given a table Twitter tweet data, write a query to obtain a histogram of tweets posted per user in 2022. Output the tweet count per user as the bucket and the number of Twitter users who fall into that bucket.In other words, group the users by the number of tweets they posted in 2022 and count the number of users in each group.tweets Table: ColumnNameTypetweet_idintegeruser_idinteg..