Scribd
Upload
3 views5 pages

ASS11

The document contains SQL insert statements for matches, players, batting, and bowling data. It also includes three queries to find specific player and match statistics based on performance criteria. The queries focus on match IDs, player IDs, and average scores in relation to specific conditions.

Uploaded by

ronitbose77
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views5 pages

ASS11

The document contains SQL insert statements for matches, players, batting, and bowling data. It also includes three queries to find specific player and match statistics based on performance criteria. The queries focus on match IDs, player IDs, and average scores in relation to specific conditions.

Uploaded by

ronitbose77
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

ASSIGNMENT 10

INSERT INTO MATCH VALUES(101, 'INDIA', 'AUSTRALIA', 'SYDNEY', TO_DATE('12-01-


2026', 'DD-MM-YYYY'), 'INDIA');
INSERT INTO MATCH VALUES(102, 'INDIA', 'SRI LANKA', 'COLOMBO', TO_DATE('15-01-
2026', 'DD-MM-YYYY'), 'SRI LANKA');
INSERT INTO MATCH VALUES(103, 'AUSTRALIA', 'SRI LANKA', 'SYDNEY', TO_DATE('17-
01-2026', 'DD-MM-YYYY'), 'AUSTRALIA');
INSERT INTO MATCH VALUES(104, 'INDIA', 'ENGLAND', 'MUMBAI', TO_DATE('19-01-
2026', 'DD-MM-YYYY'), 'INDIA');
INSERT INTO MATCH VALUES(105, 'ENGLAND', 'AUSTRALIA', 'SYDNEY', TO_DATE('19-
01-2025', 'DD-MM-YYYY'), 'ENGLAND');

INSERT INTO PLAYER VALUES(27001, 'KOHLI', 'VIRAT', 'INDIA', 1988, 'DELHI',


TO_DATE('18-08-2008','DD-MM-YYYY'));
INSERT INTO PLAYER VALUES(27002, 'SHARMA', 'ROHIT', 'INDIA', 1987, 'MUMBAI',
TO_DATE('23-06-2007','DD-MM-YYYY'));
INSERT INTO PLAYER VALUES(27003, 'SAHA', 'WRIDDHIMAN', 'INDIA', 1984, 'KOLKATA',
TO_DATE('24-10-2004','DD-MM-YYYY'));
INSERT INTO PLAYER VALUES(27004, 'DHONI', 'MS', 'INDIA', 1981, 'MUMBAI',
TO_DATE('07-07-2000','DD-MM-YYYY'));
INSERT INTO PLAYER VALUES(27005, 'SUNIL', 'NARINE', 'WEST INDIES', 1988,
'TRINIDAD', TO_DATE('26-05-2000','DD-MM-YYYY'));

INSERT INTO BATTING VALUES(101, 27001, 1, 3, 'CAUGHT', 100, 85, 90, 8, 2);
INSERT INTO BATTING VALUES(102, 27002, 1, 3, 'BOWLED', 70, 40, 55, 4, 1);
INSERT INTO BATTING VALUES(103, 27003, 1, 5, 'CAUGHT', 120, 85, 60, 7, 2);
INSERT INTO BATTING VALUES(104, 27004, 1, 5, 'LBW', 69, 40, 55, 3, 1);
INSERT INTO BATTING VALUES(105, 27005, 1, 8, 'CAUGHT', 85, 50, 70, 8, 2);
INSERT INTO BOWLING VALUES(101, 27002, 10, 2, 40, 3);
INSERT INTO BOWLING VALUES(102, 27002, 8, 1, 35, 2);
INSERT INTO BOWLING VALUES(103, 27003, 7, 2, 50, 4);
INSERT INTO BOWLING VALUES(104, 27004, 6, 2, 40, 3);
INSERT INTO BOWLING VALUES(105, 27003, 6, 2, 35, 3);

i) Find match ids of those matches in which player 27001 bats and makes more runs than he
made at every match he played at Sydney.

ii) Find player ids of players who have scored more than 30 in every ODI match that they have
batted.

iii) Find the ids of players that had a higher average score than the average score for all players
when they played in Sri Lanka.

You might also like