#94. Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000? (Choose two)
#95. Examine the data from the CLASS and INSTRUCTOR tables. You have been asked to produce a report of all instructors, including the classes taught by each instructor. All instructors must be included on the report, even if they are not currently assigned to teach classes. Which two SELECT statements could you use? (Choose two.)
#97. Examine the data from the CLASS and INSTRUCTOR tables. You want to retrieve a list of all classes, including those with no instructor currently assigned. Which SELECT statement should you use?
#98. To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
#100. Examine the data from the ORDERS and CUSTOMERS table. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?
ген. 0.071
Форум
Главный бреиндамп