For the table above named tblTable2.dbf write a SQL statement to do the following:

i. Give out all city names that end with the letter ‘i’
ii. Give out custname names that end with ‘a’
iii. Give out all city names that end with ‘asa’.
iv. Output only 50% of the records
v. Delete records of employees in Mombasa
vi. List number of orders for every city
vii. Change name of custno ‘C1003’ to ‘Juma’

Transcribed Image Text:

CUSTNO CUSTNAME CITY ORDERNO C1001 BARAZA MOMBASA 03 C1002 ZIPY NAIROBI 04 C1003 OMURWA MOLO 05 C1004 SIMIYU KIMILILI 06 C1005 CHESCAH KIMININI 07 CUSTNO CUSTNAME CITY ORDERNO C1001 BARAZA MOMBASA 03 C1002 ZIPY NAIROBI 04 C1003 OMURWA MOLO 05 C1004 SIMIYU KIMILILI 06 C1005 CHESCAH KIMININI 07