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.

e$.$ Modify the structure of table Service by adding one more column named ServiceCharges with Decimal datatype.

Answer text

Jump to$...$