SQL QUIZ TIME

Which SQL statement is used to insert new data in a database?

Except
Previously we learned the concept of INTERSECT, now lets see how EXCEPT works.
EXCEPT is directly opposite to that of INTERSECT.
EXCEPT retrieves unique records from the first SELECT statement that are not present in the output of the second SELECT statement.

Below is the format for the same:

SELECT * FROM table_1
EXCEPT
SELECT * FROM table_2;
Task
Consider the same supermarket database we used in the previous problem.
Write a query to output the name of the fruits (f_name) from the table 'fruit' which are not present in the table inventory.
f_name column has the name of the fruits and inv_name has the name of the items in inventory.

Expected output
┌────────┐
│ f_name │
├────────┤
│ Apple │
│ Mango │
│ Orange │
└────────┘

The INTERSECT operator combines two SELECT statements, but only returns the rows that are common to both SELECT statements.

Below is the format for the same:

SELECT * FROM table_1
INTERSECT
SELECT * FROM table_2;
Task
Consider a supermarket database

Table 'fruit' has the list of all fruits available in the market(few of them could be out of stock).
Table 'inventory' has the updated list of items in the supermarket.
Write a query to find the list of fruits available in the supermarket. (f_name column has the name of the fruits and inv_name has the name of the items in the inventory, you are suppose to output the name of the fruits.)

Expected output
┌────────────┐
│ f_name │
├────────────┤
│ Banana │
│ Cherry │
│ Grape │
│ Kiwi │
│ Pear │
│ Pineapple │
│ Watermelon │
└────────────┘

What is the difference between UNION and UNION ALL in SQL?