Description:
DAILY CHALLENGE
ProgramID- 9718
SkillRack
SQL - SELECT Cricket Players
A table called player is created with the following DDL command:
CREATE TABLE player(id INT, name VARCHAR(30), odimatches INT, testmatches INT, t20imatches INT);
Write the SQL query to select the id, name, odimatches, testmatches and t20imatches from the table player where the odimatches, testmatches and t20imatches are greater than 10. Note: The name of the players must be sorted in alphabetical order.
Share this link via
Or copy link



























