Please answer the following two questions:
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
PRODUCT
Recent Comments