Question: Consider the tables provided below and answer the following SQL questions: Table 1: Service Table 2: ServiceSetUp Questions: a. Write insert statements to enter first
Consider the tables provided below and answer the following SQL questions: Table 1: Service Table 2: ServiceSetUp Questions: a. Write insert statements to enter first two records into Table 1 as shown in above figure. b. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. c. Display the name of the service that has setup fee greater than $300. d. Display average of tax rates for all services
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
