Q$1$: Using table definition below write SQL statement to add yourself into the customer table. Assume that all fields require value. $(1)$

Table: customer$($cnum$,$ cname,cstreet,ccity,cprov,cpcode$)$

Q$2.$ Using table definition below write SQL statement$($s$)$ to record in the database selling product number DW$11$ to customer number $148.(4)$

Table: customer

CNUM

CNAME

CSTREET

CCITY

CPROV

CPCODE

$148$

Al's Appliance and Sport

$2837$ Greenway

Toronto

ON

$33336$

$282$

Brookings Direct

$3827$ Devon

Toronto

ON

$33321$

$356$

Ferguson's

$382$ Wildwood

Brampton

ON

$33146$

$842$

All Season

$28$ Lakeview

Oakville

ON

$1111$

Table: ORDERS

ORDER$\_$NUM

ORDER$\_$DATE

CNUM

$21608$

$20/10/2007$

$148$

$21610$

$20/10/2007$

$356$

$21613$

$21/10/2007$

$408$

Table: orderline

ORDER$\_$NUM

PART$\_$NUM

NUM$\_$ORDERED

QUOTED$\_$PRICE

$21608$

AT$94$

$11$

$21\mathrm{.}95$

$21610$

DR$93$

$1$

$495$

Table: part

PART$\_$NUM

DESCRIPTION

ON$\_$HAND

CLASS

PRICE

AT$94$

Iron

$50$

HW

$24\mathrm{.}95$

BV$06$

Home Gym

$45$

SG

$794\mathrm{.}95$

DL$71$

Cordless Drill

$21$

HW

$129\mathrm{.}95$

DR$93$

Gas Range

$8$

AP

$495$

DW$11$

Washer

$12$

AP

$399\mathrm{.}99$

FD$21$

Stand Mixer

$22$

HW

$159\mathrm{.}95$

KV$29$

Treadmill

$9$

SG

$1390$