Demonstrate that aselectstatement can be separated into two parts: The first part joins the tables and creates a new table, and the second part restricts the amount of data that is shown. For the followingselectstatement, write two SQL statements to separate these two steps.

select a.description,

b.supplier_name

from l_foods a,

l_suppliers b

where a.supplier_id = b.supplier_id

orderbya.description;