Home/ Questions/Q 1046
Next
In Process

SIKSHAPATH Latest Questions

Berlin
  • 0
  • 0
Asked: 2021-10-22T23:13:11+05:30 In:

Write a query to create a view to getting a count of how many customers we have at each level of a grade.

  • 0
  • 0
Write a query to create a view to getting a count of how many customers we have at each level of a grade.

Write a query to create a view to getting a count of how many customers we have at each level of a grade.

dbmsview
Share

    2 Answers

    2. Sam Routh

      CREATE VIEW gradecount (grade, number)

      AS SELECT grade, COUNT(*)

      FROM customer

      GROUP BY grade;

    3. Professor

      DOWNLOAD ATTACHMENT FOR ANSWER:

      Attachment

    Leave an answer

    You must login to add an answer.

    Need An Account,