Provided the following tables, write a SQL query to pull the average GPA (grade_point in table) by subject for completed…
Below is a table schema for a new messaging app. The table contains send/receive message data for the application's users.
You’re given a table called “PersonOccupation”, which is outlined below. Using SQL, pivot the “occupation” column so…
Suppose you are working for a food delivery company looking to compare delivery times across its two delivery systems (one…
Given the table below, called ‘orders’, write code to show the average revenue by month by channel. The format…
Suppose you are playing a game where there are two fair six-sided dice, and every time you roll the dice and they…