444444444444444444444444444444444447777777777777777777777777777777777777777bbbbbbbbbbbbbbbbbbb66666666

I don’t know how to handle this Computer Science question and need guidance.

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

____________________________________________

Get 20% discount on your first order with us. Use code: GET20

CHOOSE YOUR WRITER