Question: Dear student, please answer the following questions: First Question: Grade 28 A Display the student last name students that have the letters %m as their

 Dear student, please answer the following questions: First Question: Grade 28

Dear student, please answer the following questions: First Question: Grade 28 A Display the student last name students that have the letters "%m" as their third, fourth and fifth letters in their addresses, sorted in descending order, and suppress output duplicates. (4 points) "t % rn" B. List the name of each item (item desc) included on order #1 (6 points) (item_desc) 1 (1# order) C. Give the number of each player who has won at least one game and who has won neither 5 nor 6 games. Display also the number of won. (6 points) 5 6 D. Give the name and initials of each player who has incurred more than two penalties of more than 40$ (6 points) (initials) 10 Get the date of birth and the player numbers of the oldest players from "Stratford" (6 points) (Stratford) Dear student, please answer the following questions: First Question: Grade 28 A Display the student last name students that have the letters "%m" as their third, fourth and fifth letters in their addresses, sorted in descending order, and suppress output duplicates. (4 points) "t % rn" B. List the name of each item (item desc) included on order #1 (6 points) (item_desc) 1 (1# order) C. Give the number of each player who has won at least one game and who has won neither 5 nor 6 games. Display also the number of won. (6 points) 5 6 D. Give the name and initials of each player who has incurred more than two penalties of more than 40$ (6 points) (initials) 10 Get the date of birth and the player numbers of the oldest players from "Stratford" (6 points) (Stratford)

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!