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 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
Get step-by-step solutions from verified subject matter experts
