Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

3. Graph the equation f(x) = x and show the tangent at the point (2, 4) (pencil and paper please!). 4. A science project studying catapults sent a projectile into the air with an initial velocity of...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Questions 1 and 2 in this part relate to the ER model given below. The ER model illustrates the entities and relationships for modeling a stock research fine. Assume the firm has two types of staff ?...

Hi need to get done only one article from the given ones but please choose any one except article no 2 as i have already done that one. please choose right theory and apply it on the article and...

Hello, Sarah could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting...

could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting theory. I...

i need to get any one article any one can help with any other article done just except second one as its already been done 3101AFE Accounting Theory and Practice GROUP RESEARCH ASSIGNMENT Semester 1...

please do any other article except second one it been done already and please apply correct theory 3101AFE Accounting Theory and Practice GROUP RESEARCH ASSIGNMENT Semester 1 2016 A. OVERVIEW The...

two articles needs to be done according to the given requirement in the attatched file 3101AFE Accounting Theory and Practice GROUP RESEARCH ASSIGNMENT Semester 1 2016 A. OVERVIEW The research...

Although it may seem fairly obvious that receiving praise and recognition from ones company is a motivating experience, sadly, many companies are failing miserably when it comes to saying thanks to...

The following is an excerpt from a disclosure note of Johnson & Johnson: 15. Financial Instruments (in part) As of December 28, 2008, the balance of deferred net gains on derivatives included in...

Which regulation provides information regarding instrument range markings for an airplane certificated in the normal category? Group of answer choices 1 4 CFR Part 2 5 . 1 4 CFR Part 2 1 . 1 4 CFR...

As discussed in Chapter 1, the International Accounting Standards Board (IASB) develops accounting standards for many international companies. The IASB also has developed a conceptual framework to...

Consider each of the following assets and liabilities which appear in a company's statement of financial position at 30 April 2018: (a) A motor lorry which cost 100,000 is shown at its written down...

Is it morally acceptable to use a denial-of-service attack to shut down a Web server that distributes child pornography?

What is the difference between a control that includes the runat attribute set to "server" and one that does not?

The American Association of Engineering Societies (AAES) hired Harris Interactive to conduct a survey of the American publics knowledge of and interest in engineering. (AAES/Harris Poll American...

Can we put that she will be making weekly payroll deductions inthe amount of $52.75 to the housing equalling $211.00 monthly

On January 1, 2012, Peet Development Company paid $325,000 in cash for a parcel of land to be used as the new office building site. During March, the company petitioned the city council to rezone the...

In the United States, accounting for inventory is a difficult issue. Inventory is comprised of those items either purchased or manufactured to be resold at a profit. Numerous methods are available to...

The following are possible performance measures of customer satisfaction: 1. Purchase cost to customer 2. Customer defection rate 3. Returns by customers 4. Number of new customers 5. Time to...

In anticipation of issuing of long-term bonds, a state issues on May 1, 2015 $200 million of 60-day BANs to nance highway construction. It expects to roll over the BANs into long-term bonds within 60...

The City of Faireld issued $100 million of 20-year, 6 percent coupon bonds (3 percent per semiannual period) for $89.32 million. The price reected a yield of 7 percent (3.5 percent period semiannual...

The East Eanes School District engaged in or was affected by the following events and transactions during its scal year ending June 30, 2015. 1. Teachers and other personnel earned $350,000 in...