+1 (208) 254-6996 essayswallet@gmail.com
  

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

Week 9 - q2.png

PRODUCT

Week 9 - q2-.png