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
4 years ago 6
Answer(1)
Purchase the answer to view it
NOT RATED
- SQL.edited.docx
- SQL1.docx
- sql1.pdf
other Questions(10)
- 15 page research paper on personality of psychology class
- Online World Literature course
- Tentative Policy Suggestions and sources for Employee use of Internet at work.
- HUM 130 Week 6 DQ 1
- CMGT 554 Week 3 Individual Assignment Patton-Fuller Community Hospital Networking Project
- week 5 assign [BA460]: [Public Relations]
- Expert-Writer
- A golf ball manufacturer desires to compare the distance traveled by golf balls using four unique designs
- Persuasive essay and final project
- only qualified tutors