Exercise #18 (computer firm) | Interactive tutorial on SQL | SQL-tutorial.ru

Русский

English

21:04

			Content	Login

		SQL Problems and solutions S. I. Moiseenko

back go forward

	Typical mistakes at the solution of SELECT statement exercises Database "Computer firm" Exercise #18
	Find the makers of the cheapest color printers. Result set: maker, price. Find two mistakes in the following solution to this task: Console Execute SELECT c.maker, a.priceA price FROM (SELECT MIN(price) priceA FROM Printer WHERE color ='y' ) a INNER JOIN Printer b ON a.priceA = b.price INNER JOIN Product c ON b.model = c.model; SELECT c.maker, a.priceA price FROM (SELECT MIN(price) priceA FROM Printer WHERE color ='y' ) a INNER JOIN Printer b ON a.priceA = b.price INNER JOIN Product c ON b.model = c.model; Scheme T&S To solve the problem on SQL-EX.RU mistakes printer inner join exercises 18

Previos [Exercise #17]

[Exercise #20] Next

Last added:

donate

Tags

aggregate functions Airport ALL AND AS keyword ASCII AVG Battles Bezhaev Bismarck C.J.Date calculated columns Cartesian product CASE cast CHAR CHARINDEX Chebykin check constraint classes COALESCE common table expressions comparison predicates Computer firm CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema date/time functions DATEADD DATEDIFF DATENAME DATEPART DATETIME DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates EXCEPT exercise (-2) exercise 19 exercise 23 exercise 32 More tags

The book was updated
several days ago

©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.