Question

What is Structured Query Language (SQL)? And also write SQL Queries for the followings. Student ( Sid, Smarks, Sbranch) 1) Retrieve highest marks from the student table. 2) Retrieve Sid of student who scored highest marks among all. 3) Retrieve Branches whose average marks is greater than 50

Answer 1

Answer:

Hindi tamil Telugu karnataka rajasthan

Answer 2

Explanation:

SQL (Structured Query Language) is a standardized programming language for managing relational databases and performing operations on the data contained within them. SQL is a database language that allows you to store, manipulate, and retrieve data. SQL statements are used to conduct operations like updating data in a database and retrieving data from one.

SQL Queries:

1.Select max(Smarks) AS HighestMarks

 From Student

2.Select max(Smarks) AS HighestMarks, Sid AS StudentId

 From Student

3.Select Sbranch AS Branch

 From Student where avg(Smarks)  > 50