W10 March 15 ✓
Agenda
Updates and Important Housekeeping
New Kaggle pathway for data analytics. More Info >
Absent Last Week? Complete the Survey: T-shirt Sizes and Summer Plans https://form.jotform.com/240674228249057
Apply for Techpoint Xplore Program ⌛ https://techpoint.org/xplore-students/
Data Students Complete the data analytics exercise (more SQL) then continue progress on Coursera or Kaggle
Robotics Students
Didn't Pass the Badge Quiz Last Week?: You can still do it. Review the slides from last week and complete the assessment 🚀
Cobot training: Working with Pallets and Bin Boxes
SQL: Functions and GROUP BY
Exercise
Today we will use Structured Query Language (SQL) to pull data from a movie database. SQL, like spreadsheets, is an indispensable tool for data analysts.
Demo
COUNT, SUM, AVG, GROUP BY
Constructing SQL Statements
Construct the appropriate SQL statements to satisfy each of the following requests. Use the LaunchBoard SQL Lab to test your statements.
Determine the number of movies released by
year. Order byyear.Determine the total number of votes collected (
vote_count) for all thriller movies byyear. Order byyear.Determine the total
revenuefor adventure movies by year. Order by descending total revenue.Determine the average of the
vote_averagefor all comedies byyear. Order by descending vote average.Determine the average profit for adventure movies by
year. Remember that profit is calculated as(revenue - budget). Removerevenueandbudgetvalues that are < 0. Order by descending profit.
Review the Pacing with the Coursera coursework
Last updated