Assignment-iv.docx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Assignment-iv.docx as PDF for free.
More details
- Words: 98
- Pages: 1
ASSIGNMENT - IV
1. Considering the following relations: Player(Jersey_no, Player_name, Against, Run) Team(Jersey_no, Team_name) Serve the SQL queries: a) Find out the names of the players whose 2nd letter of the name is ‘E’. b) Find out the total runs scored in the tournament by Tendulkar. c) Find out the Jersey number, Player name and Team name of every player in ascending order. d) Display Player name and run of the player who scored the highest run against India. e) Display Player name and run of the player who scored the highest run against India and Sri Lanka.
1. Considering the following relations: Player(Jersey_no, Player_name, Against, Run) Team(Jersey_no, Team_name) Serve the SQL queries: a) Find out the names of the players whose 2nd letter of the name is ‘E’. b) Find out the total runs scored in the tournament by Tendulkar. c) Find out the Jersey number, Player name and Team name of every player in ascending order. d) Display Player name and run of the player who scored the highest run against India. e) Display Player name and run of the player who scored the highest run against India and Sri Lanka.
More Documents from "Rupsa Sen"
Day4.docx
April 2020 24
Oodbms And Ordbms.docx
April 2020 6
Assignment-iv.docx
April 2020 8
Poverty: Not A Word Only
October 2019 26
Lesson05.doc
October 2019 14