25 Practice SQL Questions for Beginners

Learn to count unique title IDs in the title author table, understand composite primary keys, and use group by and order by to rank titles by author count.

Practice joining authors and title_author to fetch three authors' first and last names for a given title, assess ownership by author, and add the book price from the titles table.

Practice summing values and calculating averages using year-to-date cells, convert null sums to zero, and order results by the sum while analyzing the average by title type.

Learn to compute minimum and maximum year-to-date sales by title types, count titles, and apply a having clause to show groups with more than two titles, using group by.

Extract distinct states from the authors table, count cities by state with group by, and filter with where in for California, Utah, and Oregon.

Explore using a case statement to map states to regions and add a region column, then group by that region to count cities and active authors by contract.

Explore SQL querying techniques on the publishers table using like and wildcards to find titles starting with the 'the', notes containing 'computer', and titles not of type 'business'.

Use the concatenate function to create full names, join authors with the title author table, and count ids; filter California authors with multiple books using having and order by count.

Learn to count titles published between may 1, 2021 and august 31, 2021 using between and where, with a case statement and date name approach.

Learn to find titles with a single author by joining titles to title_author, counting author_id, or using royalty_type = 100, then filter by an expired contract in authors.

Insert data into the stores table using column lists and values. Update a store name and delete a row, using select to verify changes.

Create the audiobooks table with its columns, insert data, join with the titles table to locate the title with an audio book, then drop the table.

Learn to identify which titles exist in the titles table but not in the sales table using a subquery in the where clause, and explore why unpublished titles lack sales.

Join publishers with employees, count employees per publisher, group by publisher name, and order by count descending; then compute the average job level excluding California and New York.

Learn how to update data in the authors table and verify changes with select statements, then apply a self join to identify four authors sharing two addresses.

Learn to compute the number of books needed to recoup an author's advance using the advance and price columns, while formatting results with currency and comma separators.

Walk through building a query to compute quantity sold and a break-even flag using inner and left joins, grouping, and a case statement across 18 titles.

Walks through inserting a new employee into the employee table, deriving job level from the jobs table and publisher id from the publishers table, then deleting the record to revert.

This video explains question 24: add a gender column to the employee table, update it from the last ID character to male or female, then drop the column.