Write SQL queries using comparison and logical operators such as AND, OR, BETWEEN, IN, and IS NULL
Construct multi-table queries using full column names and table joins
Apply aggregate functions with HAVING and ORDER BY to filter and sort grouped results
Define database tables and load data into them
Understand and use transactions to manage database changes
