22. SQL -select, where, like, as, distinct, and order by keywords

Description:
To create the database used in this video, click on the following links:
https://youtu.be/OU4MGpDb6eI
https://youtu.be/U8Xen54ITSY

Click the link below to view/download the document containing the queries used in this video:
https://drive.google.com/file/d/198AgCwQHtd1p5QBpIB3_TJlhT0XopfRs/view?usp=sharing

Review Questions:
1. Explain the use of distinct keyword in SQL.
2. When do we use the where clause in SQL?
3. Does the select query modify the actual data in the database? Yes/No?
4. Which of the following symbols is used to represent any one character using the like keyword in SQL?
a. %
b. _
c. $
d. #
5. Which of the following symbols is used to represent zero or more characters using the like keyword in SQL?
a. %
b. _
c. $
d. #
6. What is the default order of sorting performed by the order by clause in SQL?
a. Ascending
b. Descending
7. What does the 'AS' keyword do in SQL?