Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part C - Writing SQL scripts for basic queries (1.5 marks) Individual take home exercises. You need to show your scripts and print screens

 

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting concepts and applications

Authors: Albrecht Stice, Stice Swain

11th Edition

978-0538750196, 538745487, 538750197, 978-0538745482

More Books

Students also viewed these Databases questions

Question

Factor by grouping. x 2 + 3x - 3y - xy

Answered: 1 week ago

Question

Why is it important to analyze your spending habits?

Answered: 1 week ago