Part C - Writing SQL scripts for basic queries (1.5 marks) Individual take home exercises. You...

 

Transcribed Image Text:

Part C - Writing SQL scripts for basic queries (1.5 marks) Individual take home exercises. You need to show your scripts and print screens of results to your tutor next week. Continue with mobile database, write the SQL scripts for the following queries: a) List all mobile phones on the Yes10 mobile plan. Display all their details. b) Show all customers that have the letter "i" in their surname. Sort this list in descending order by suburb. (Hint: In MySQL, use % as a wildcard) c) List all staff who have a rate per hour that is less than $17 and who have not yet resigned. Part C - Writing SQL scripts for basic queries (1.5 marks) Individual take home exercises. You need to show your scripts and print screens of results to your tutor next week. Continue with mobile database, write the SQL scripts for the following queries: a) List all mobile phones on the Yes10 mobile plan. Display all their details. b) Show all customers that have the letter "i" in their surname. Sort this list in descending order by suburb. (Hint: In MySQL, use % as a wildcard) c) List all staff who have a rate per hour that is less than $17 and who have not yet resigned.