mistakes | SQL-tutorial.ru

Tag > mistakes

Typical mistakes at the solution of SELECT statement exercises

Exercise #1

More tags: PC, exercise 1, product, tables join

Exercise #2

More tags: exercise 2, printer, product

Exercise #6

More tags: Cartesian product, IN, exercise 6

Exercise #8

More tags: PC, WHERE, exercise 8, laptop, predicates

Exercise #10

More tags: exercise 10, printer

Exercise #13

More tags: AVG, average value, exercise 13, subquery

Exercise #15

More tags: DISTINCT, EXISTS, PC, exercise 15

Exercise #16

More tags: PC, exercise 16

Exercise #17

More tags: Cartesian product, DISTINCT, exercise 17

Exercise #18

More tags: exercises 18, inner join, printer

Exercise #23 [1,2,3,4]

Exercise #59

More tags: GROUP BY, exercise 59, subquery

Exercise #60

More tags: CONVERT, data type conversion, exercise 60

Exercise #39 [1,2,3,4]

More tags: Battles, EXISTS, Outcomes, exercise 39

Exercise #56 [1,2,3,4,5]

Exercise #57 [1,2]

More tags: LEFT OUTER JOIN, exercise 57, sunken ships

Exercise #59 (tips and solutions)

More tags: COALESCE, ISNULL, exercise 59, tips and solutions

Exercise #60 (tips and solutions)

More tags: FULL JOIN, NULL, exercise 60, tips and solutions

Exercise 11 (rating)

More tags: PC, exercise 11, product, relational division