Question: A. Display the student last name students that have the letters t%m as their third, fourth, and fifth letters in their addresses, sorted in descending
Dear student, please answer the following questions: |28 Grade |First Question: : 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) "1 % m" . B. List the name of each item (item_desc) included on order #1. (6 points) (order #l 1 (itern_desc) 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 405. (6 points) (initials) 40 E. 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: |28 Grade |First Question: : 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) "1 % m" . B. List the name of each item (item_desc) included on order #1. (6 points) (order #l 1 (itern_desc) 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 405. (6 points) (initials) 40 E. 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
