Question: run:yes'> Computer Architecture: Please solve these queries using MySQL with sakila and world database that comes with default mySql. 1. What is the address, district

run:yes'> Computer Architecture:

Please solve these queries using MySQL with sakila and world database that comes with default mySql.

1. What is the address, district and phone number of each of the customers?

2. What is the city and country of each of the customers?

3. List all the films by every actor

4. Display the first and last name of each actor in a single column in upper case letters

5. Show The capital of A is B where A is the name of country and B is its capital from country

table-

a. In upper case

b. Lower case

6. What is the length of the password of the account of each staff?

7. What is the length of the email address of the customers without domain name?

8. Round the population of the countries in million

9. Show the life expectancy in years only for each continent

10. What is your age in months?

11. What is the date after 167 days?

12. What is the total population of each district? (Use city table)

13. How many districts in each country? (Use city table)

14. What is the total population of each continent?

15. Which country has the maximum population?

16. What is the average population of the world?

17. What is the minimum life expectancy of the world?

18. How many actors acted in each film? (hints: use film_actor table)

19. What is the minimum length of a film?

20. What is the average rating of the film?

please write the Quires to solve the question using mysql application.

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 Programming Questions!

Q:

Ohio Corporation has 6 million shares of common stock priced at $25 per share, which has just paid its annual dividend of $1.75. The dividends have grown steadily at the rate of 5% per year and the...

Q:

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Q:

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

Q:

Assignment: Based on your reading and analysis of the case study above, address the following items in a detailed essay response of approximately 600 words. Each number below should be addressed...

Q:

Cell Phone Experiment 1 Is there enough evidence to infer that women drivers in a following car are more likely to honk when the lead car driver is using a cellphone? Driver in following car was...

Q:

Why has the share of healthcare output produced by hospitals risen? Will this trend continue? Can you think of a policy or technology change that would reduce hospital use? Can you think of a policy...

Q:

Identify important people and psychological instruments in the history of intellectual and personality assessment.

Q:

1. Based on the facts presented in the case, how should the recruiter analyze the data? Hint: Can the recruiter obtain the information needed to make a decision by simply looking at the worksheet?...

Q:

Which of the following statements is correct? If corporate tax rates were increased while other things were held constant, and if the Modigliani-Miller tax-adjusted tradeoff theory of capital...

Q:

How has the study of finance changed since the beginning of the twentieth century?

Q:

In the most cases , the commercial activities of companies required the use of fund or property that belongs to the company . Briefly describe the source of fund generally referred to as company's...

Q:

Business Operations Management - Tutorial 1 When we define a 'system' (in this case the system represents our operation) we make judgements about where to draw boundaries. In this context the supply...

Q:

Promotions should satisfy several business rules. One such rule is to limit the frequency of promotions for a particular SKU. For example, a retailer may insist that a particular product is promoted...

Q:

A program in Python that outputs the common names of five of the world's smallest known bird species. Your output should include the common name and size of each species. You can find this...

Q:

Consider Peter Drucker's well-known statement that "Culture eats strategy for breakfast." Do you think that Drucker is right? If not, why not? Explain your reasoning. Please use references

Q:

1. A brief paragraph introducing Coca Cola company, its cyber environment and provide a high-level overview of Coca Cola's need for a cyber risk mitigation strategy. (Paragraph introducing Coca Cola...

Q:

Chads Dye Company, Inc manufactures a red industrial dye. The company is preparing its master budget for the first quarter and has presented you with the following information. 1. The December...

Q:

Fill in each blank so that the resulting statement is true. 83 + 103 = ______ .

Q:

25. Independent trials, resulting in one of the outcomes 1, 2, 3 with respective probabilities p1, p2, p3, 3i =1 pi = 1, are performed. (a) LetN denote the number of trials needed until the initial...

Q:

Let X be uniformly distributed over (0, 1). Calculate E[X 3 ].

Q:

44. The number of customers entering a store on a given day is Poisson distributed with mean = 10. The amount of money spent by a customer is uniformly distributed over (0, 100). Find the mean and...