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…
Profitable Stocks
A stock is considered profitable if the predicted price is strictly greater than the current price. Write a query to find the…
Country Code
A company wants to contact each of its customers regarding the policy changes. They have international customers, but their database does not…