Using Structured Query Language (SQL), create a query that gets the following data from the sakila database: Actor Last Name, Actor First Name, Film Title For all actors with a last name that begins with M In alphabetical order by Actor's Last Name

1 answer
Question:

Using Structured Query Language (SQL), create a query that gets the following data from the sakila database:
Actor Last Name, Actor First Name, Film Title
For all actors with a last name that begins with M
In alphabetical order by Actor's Last Name

Answers

Queries to get data from sakila database using Structured Query Languange (SQL): Assuming that you have created a Database already, with tables in it, containing at least 50 records and these fields: ACTOR_LASTNAME, ACTOR_FIRSTNAME, FILM_TITLE Take note that the database and table name is both "sakila". 1. We can fetch, display or get data using SELECT command or query. Let's type the command like this: SELECT ACTOR_LASTNAME, ACTOR_FIRSTNAME, FILM_TITLE FROM sakila   The command above is called SELECT command that would allow you to display records inside your table. Normally SQL programmers would execute SELECT * command, but since we are just required to display three (3) columns only, then we could just select the column names for our data display. Your columns are: SELECT ACTOR_LASTNAME, ACTOR_FIRSTNAME and FILM_TITLE. 2. For the second command or query, we can execute this: SELECT ACTOR_LASTNAME FROM sakila WHERE ACTOR_LASTNAME 'M%' ORDER BY ACTOR_LASTNAME . The select where command is like a conditional statement (IF). Where is the statement used to display ACTOR_LASTNAME field starting with letter M. The ORDER BY command is the arrangement of the names in alphabetical order.  

Similar Solved Questions

2 answers

The book of kells is an example of:A. a Greco-roman myth B. an illuminated manuscript C. a Byzantine religious text D. an iconoclastic masterpiece

the book of kells is an example of:A. a Greco-roman myth B. an illuminated manuscript C. a Byzantine religious text D. an iconoclastic masterpiece...
1 answer

What’s the slope ? I don’t understand

What’s the slope ? I don’t understand...
1 answer

Several factors can cause tire failure including under inflation, hard braking, and __________.

Several factors can cause tire failure including under inflation, hard braking, and __________....
1 answer

Calculate the volume of an object with dimensions measuring: 1 m x 3 m x 2 m= [?]m^3

Calculate the volume of an object with dimensions measuring: 1 m x 3 m x 2 m= [?]m^3...
1 answer

Which number line shows the solution to 6+ (-6)​

which number line shows the solution to 6+ (-6)​...
1 answer

How do trade-offs decided by corporations and government impact our lives?

How do trade-offs decided by corporations and government impact our lives?...
1 answer

Find the 11th term of the following geometric sequence. 1,5, 25, 125, ...

Find the 11th term of the following geometric sequence. 1,5, 25, 125, ......
2 answers

What is described by the VSEPR theory? O A. The arrangement of atoms in a molecule B. The oxidation numbers of atoms in a molecule C. The kind of bonds formed in a molecule O D. The outside forces operating on a molecule

What is described by the VSEPR theory? O A. The arrangement of atoms in a molecule B. The oxidation numbers of atoms in a molecule C. The kind of bonds formed in a molecule O D. The outside forces operating on a molecule...
1 answer

I need help Hdjshhsjsmanana

I need help Hdjshhsjsmanana...
1 answer

The difference in Decision Making Under Risk and decision making under uncertainty is that under risk, we think we know the probabilities of the states of nature, while under uncertainty we do not know the probabilities of the states of nature. True False

The difference in Decision Making Under Risk and decision making under uncertainty is that under risk, we think we know the probabilities of the states of nature, while under uncertainty we do not know the probabilities of the states of nature. True False...
1 answer

A car is driving directly south down a road. It slows down to stops at a few stop signs, and then, accelerates up to 30 miles per hour. Is the car's velocity changing? Why or why not?

A car is driving directly south down a road. It slows down to stops at a few stop signs, and then, accelerates up to 30 miles per hour. Is the car's velocity changing? Why or why not?...
1 answer

What was the result of the construction of the transcontinental railroad after the civil war

What was the result of the construction of the transcontinental railroad after the civil war...
1 answer

A boat with a horizontal tow rope pulls a waterskier. She skis off to the side, the rope makes an angle of 15° with the forward direction of motion. If the tension in the rope is 180 N, how much work does the rope two on the scare during the forward displacement of 300 m?

A boat with a horizontal tow rope pulls a waterskier. She skis off to the side, the rope makes an angle of 15° with the forward direction of motion. If the tension in the rope is 180 N, how much work does the rope two on the scare during the forward displacement of 300 m?...
1 answer

What's this problem in simple form? (attachment)

What's this problem in simple form? (attachment)...
1 answer

During his life, Giovanni da Palestrina was devastated to lose to the plague. A. a few distant relatives B. all the family pets C. his brother, wife, and two sons​

During his life, Giovanni da Palestrina was devastated to lose to the plague. A. a few distant relatives B. all the family pets C. his brother, wife, and two sons​...
2 answers

What are the two important features, that help the root hair cells to absorb water from the soil?

What are the two important features, that help the root hair cells to absorb water from the soil?...
1 answer

Mr. Alvarez makes a walkway out of 3 cement slabs. He uses 14 cubic feet of cement to make the walk way. Each square slab has a volume of 4 cubic feet. How many cubic feet of cement is the middle slab

Mr. Alvarez makes a walkway out of 3 cement slabs. He uses 14 cubic feet of cement to make the walk way. Each square slab has a volume of 4 cubic feet. How many cubic feet of cement is the middle slab...
2 answers

Zachary bought a baseball for $9.96, a bat for $10.05, and a glove for $19.75. About how much did he pay for the three items? $40 $40 $50 $50 $30 $30 $20 $20

Zachary bought a baseball for $9.96, a bat for $10.05, and a glove for $19.75. About how much did he pay for the three items? $40 $40 $50 $50 $30 $30 $20 $20...
2 answers

Jason earned $54 at his job when he worked for 4 hours. What was his hourly pay rate in hours per dollar? Express your answer in simplest form.'

Jason earned $54 at his job when he worked for 4 hours. What was his hourly pay rate in hours per dollar? Express your answer in simplest form.'...
1 answer

PLEASE HELPPP PLEASE The graph below shows the distance traveled by the skateboarder on each of the different road conditions. Using the graph, determine which of the roads was dry, wet, or muddy. Explain your answer using complete sentences. A bar graph showing the distance traveled in meters on each road. Road A=eight meters Road B=two meters Road C=12 meters Road A Road B Road C

PLEASE HELPPP PLEASE The graph below shows the distance traveled by the skateboarder on each of the different road conditions. Using the graph, determine which of the roads was dry, wet, or muddy. Explain your answer using complete sentences. A bar graph showing the distance traveled in meters on ea...

-- 0.013236--