Question

Write select statements for the following key words 1. OR 2. AND 3. NOT 4. GROUP BY 5. ORDER BY Pls give me the correct answer

Answer 1

Answer:

See Below

Explanation:

1.OR :

The OR operator displays a record if any of the conditions separated by OR is TRUE.

2. AND :

The AND operator displays a record if all the conditions separated by AND are TRUE.

3.NOT :

The NOT operator displays a record if the condition(s) is NOT TRUE.

4.GROUP BY :

The GROUP BY statement is often used with aggregate functions

5. ORDER BY : The ORDER BY keyword sorts the records in ascending order by default.