YOUR AD GOES HERE

SQL - SELECT Cricket Players | SkillRack | DAILY CHALLENGE | ProgramID 9718

Published 19, Dec 2023

Learning World


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.

Releted More Videos

You May Also Like

YOUR AD GOES HERE

YOUR AD GOES HERE