Youngest Employee
There are two data tables with employee information: EMPLOYEE and EMPLOYEE_UIN. Query the tables to generate a list of all employees who are less…
Scheduling Errors
Write a query to return a list of professor names and their associated courses for all courses outside of their departments. There…
Largest Number of Orders
A company maintains information about its orders in table called ORDERS. Write a query to find the CUSTOMER_ID of the customer who has placed the…
Customer Spending
List all customers who spent 25% or less than the average amount spent on all invoices. For each customer, display their name…
Products Without Sales
Given the product and invoice details for products at an online store, find all the products that were not sold. For each…