SQL Exercises

Collection of exercises using SQL

Current Exercises

• transaction-filtering/

  • Practices WHERE and HAVING
  • Answers the question: "Amount transactions greater than $5, which categories have total spending above $15, sorted highest to lowest?"

• library_data/

  • Practices summarizing data
  • Ordering books by year
  • Total number of books per genre
  • Average rating per genre
  • Genres with average rating greater than 4.4
  • Top 3 longest books (by pages)

• customer-transaction-history-data/

  • Practices summarizing data
  • Orders sorted by year
  • Total revenue per category
  • Top 2 customers by total spending
  • Categories where total revenue is greater than $1000
  • Average order value per year
  • Row count
  • Customer count
  • Max price
  • Min price
  • Average price

• left_join_project/

  • Practices merging two tables with LEFT JOIN
  • Summarizes data