Useful StuffLast updated: 2021-03-04

Here some useful stuff for SQL

1.1 Where

1.2 Is Null

1.3 Select Top

1.4 In Operator

1.5 Between Operator

1.6 Join

1.7 Having

1.7 All Operator

The ALL operator:

returns a boolean value as a result.
returns TRUE if ALL of the subquery values meet the condition.
is used with <SELECT>, <WHERE> and <HAVING> statements.

1.7 Case

Practice

These practice use opensource sample database: Sakila DVD rental store. The contents of the sakila database files are licensed under the New BSD license, Copyright © 2007, 2021, Oracle and/or its affiliates.

2.1 Quiz

Here some Quiz for practice:

Question 1	Display the total amount rung up by each staff member in August of 2005.
Question 2	Is 'Academy Dinosaur' available for rent from Store 1 ?

2.2 Answer

>>

REFERENCES :

SQL tutorial. (n.d.). Retrieved April 06, 2018, from https://www.w3schools.com/sql/.
Sakila queries exercise. (n.d.). Retrieved April 06, 2018, from https://datamastery.gitlab.io/exercises/sakila-queries.html/
SQL example work Using Sakila schema test database. (n.d.). Retrieved April 06, 2018, from https://lyniguez.github.io/SQL-Example-Work/
SQL tutorial for Beginners: Learn SQL in 7 days. (n.d.). Retrieved November 06, 2018, from https://www.guru99.com/sql.html