476 9

1- Why is it important to learn SQL? In which jobs you need to know SQL?

2A- What is the definition of DML and DDL? Give examples in each case.

2B- Consider the following two tables below: VENDOR and PRODUCT.

Write a SQL statement for each of below:

a) Show all Vendor names, vendor phone numbers in VENDOR table

b) Show all products sold by Gomez Bros.

c) Show all products with a price of greater than $100.

VENDOR