Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions