Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 order, and suppress output duplicates. B. List the name of each item (item_desc) included on order #1. 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. D. Give the name and initials of each player who has incurred more than two penalties of more than 40$. E. Get the date of birth and the player numbers of the oldest players from "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) 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)
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 order, and suppress output duplicates.
B. List the name of each item (item_desc) included on order #1.
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.
D. Give the name and initials of each player who has incurred more than two penalties of more than 40$.
E. Get the date of birth and the player numbers of the oldest players from "Stratford''
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started