No products in the cart.

Write SQL commands for the following: …



Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Write SQL commands for the following: - (i) Display all students' information. (ii) Display Rohan Saini's information. (iii) Display number of students in the table. (iv) Display number of students in each gender. (v) Display students' information in ascending order using name. (vi) Display students' information in descending order using average marks. (vii) Display students' name starting with letter "K". (viii) Display students' information, whose name ends with "l". (ix) Display a report with adno,name,average*5 as total marks from student table. (x) Display students' information, whose average marks are in between 80 to 90. (xi) Display students' info., who are getting average marks of more than 80 and scode 333. (xii) Display students' name and average marks, whose scode is 222 and 333. (xiii) Display sum of average marks. (xiv) Display maximum average marks (xv) Display minimum average marks. (xvi) Display average value of average marks. (xvii) Display maximum, minimum and sum of average marks in each scode. (xviii) Display number of students in each scode
  • 0 answers

Related Questions

What is List
  • 1 answers
In python
  • 1 answers
What is python ?
  • 1 answers

myCBSEguide App


Trusted by 1 Crore+ Students

Question Paper Creator

  • Create papers in minutes
  • Print with your name & Logo
  • Download as PDF
  • 5 Lakhs+ Questions
  • Solutions Included
  • Based on CBSE Syllabus
  • Best fit for Schools & Tutors

Test Generator

Test Generator

Create papers at ₹10/- per paper

Download myCBSEguide App