Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

You must login to add post.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

mcqoptions.com

mcqoptions.com Logo mcqoptions.com Logo

mcqoptions.com Navigation

  • Home
  • About Us
  • Contact Us
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • About Us
  • Contact Us
Home/ Questions/Q 481632
Next
In Process
Padmini Goel
Padmini Goel
Asked: 3 years ago2022-11-11T20:59:28+05:30 2022-11-11T20:59:28+05:30In: General Awareness

Consider the table EXAM given below. Write SQL commands for (i) to (iv) and output for (v) to (vii).

                     Table : EXAM

S.No.NameStipendSubjectAverageDivision
1Karan400English68First
2Aman600Mathematics72First
3]aved500Accounts67First
4Bishakha200Informatics55Second
5Sugandha400History35Third
6Suparna550Geography45Third

(i) To list the names of those students who have obtained Division as FIRST in the ascending order of NAME.

(ii) To display a report listing NAME, SUBJECT and Annual stipend received assuming that the Stipend column has monthly stipend.

(iii) To count the number of students who have either accounts or informatics as subject.

(iv) To insert a new row in the table: 6, Mohan, 500, English, 73, Second.

(v) SELECT AVG(Stipend) from EXAM where DIVISION = “THIRD”;

(vi) SELECT COUNT(DISTINCT Subject) FROM EXAM;

(vii) SELECT MlN(Average) from EXAM where Subject =”English”;

Consider the table EXAM given below. Write SQL commands for (i) to (iv) and output for (v) to (vii).

                     Table : EXAM

S.No.NameStipendSubjectAverageDivision
1Karan400English68First
2Aman600Mathematics72First
3]aved500Accounts67First
4Bishakha200Informatics55Second
5Sugandha400History35Third
6Suparna550Geography45Third

(i) To list the names of those students who have obtained Division as FIRST in the ascending order of NAME.

(ii) To display a report listing NAME, SUBJECT and Annual stipend received assuming that the Stipend column has monthly stipend.

(iii) To count the number of students who have either accounts or informatics as subject.

(iv) To insert a new row in the table: 6, Mohan, 500, English, 73, Second.

(v) SELECT AVG(Stipend) from EXAM where DIVISION = “THIRD”;

(vi) SELECT COUNT(DISTINCT Subject) FROM EXAM;

(vii) SELECT MlN(Average) from EXAM where Subject =”English”;

Parabola
  • 0
  • 11
  • 2
  • 0
  • 0
    • Report
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
    • Share on WhatsApp
Leave an answer

Leave an answer
Cancel reply

Browse

1 Answer

  • Voted
  • Oldest
  • Recent
  • Random
  1. 989d0
    2022-11-12T01:23:31+05:30Added an answer about 3 years ago

    (i)  SELECT NAME FROM Exam WHERE Division  =”First” ORDER By Name;

    (ii) SELECT NAME, SUBJECT, STIPEND * 12 FROM EXAM;

    (iii) SELECT COUNT(*) FROM EXAM WHERE SUBJECT IN (‘Accounts’,’Informatics’);

    (iv) INSERT INTO EXAM VALUES (6,”Mohan”‘ 500, “English”, 73, “SECOND”);

    (v) 475

    (vi) 6

    (vii) 68

    • 0
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report

Sidebar

Ask A Question

Stats

  • Questions 500k
  • Answers 393k
  • Best Answers 0
  • User 1
  • Popular
  • Answers
  • Aditi Dugal

    How to approach applying for a job at a company ...

    • 7 Answers
  • Raghavan Prasad Hayer

    How to handle personal stress caused by utterly incompetent and ...

    • 5 Answers
  • Ankita Dinesh Biswas

    What is a programmer’s life like?

    • 5 Answers
  • 47e0c
    47e0c added an answer Correct Answer - Increasing the yield of animals and improving… November 12, 2022 at 9:56 am
  • b6699
    b6699 added an answer Sender\'s addressDateReceivers name and addressSubjectContentYours faithfullyName November 12, 2022 at 9:56 am
  • 10eb8
    10eb8 added an answer Any uncertinity in measurment is known as errorDifference in true… November 12, 2022 at 9:56 am

Related Questions

  • The units of length, velocity and force are doubled. Which ...

    • 1 Answer
  • The penetration of light into the region of geometrical shadow ...

    • 1 Answer
  • if ` veca , vecb ,vecc ` are three vectors ...

    • 1 Answer
  • What is the value of isothermal bulk modulus of elasticity ...

    • 1 Answer
  • निम्न में से किस अणु का सेवाधिक द्विध्रुव आघूर्ण है ...

    • 1 Answer

Top Members

Trending Tags

Class 11 Parabola Polity Polynomials Probability Projectile Protists Quadrilaterals Rario Reasoning Sampling Social Solutions Spectroscopy Switchgear Thermodynamic Tourism Transients Upsc Wbjee

Explore

  • Home
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Tags
  • Badges
  • Users

Footer

mcqoptions.com

About

MCQOptions.com

Here are the top interview questions, example answers, tips for giving the best response.

About Us

  • About Us
  • Contact Us

Legal Stuff

  • Terms of Use
  • Privacy Policy
  • Cookie Policy

Follow

© 2022 MCQOptions. All Rights Reserved

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.