हिंदी

Write query based upon item table given. Display average value of average marks.

Advertisements
Advertisements

प्रश्न

Write query based upon item table given.

Students

Adno Name Average Sex Scode
501 R.Jain 98 M 111
545 Kavita 73 F 333
705 K.Rashika 85 F 111
754 Rahul Goel 60 M 444
892 Sahil Jain 78 M 333
935 Rohan Saini 85 M 222
955 Anjali 64 F 444
983 Sneha Aggarwal 80 F 222

Display average value of average marks.

कोड लेखन
Advertisements

उत्तर

SELECT AVG(Average) FROM Students;
shaalaa.com
  क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
अध्याय 10: Structure Query Language - EXERCISE [पृष्ठ २०१]

APPEARS IN

सीबीएसई Computer Science with Python [English] Class 12
अध्याय 10 Structure Query Language
EXERCISE | Q 28. (xvi) | पृष्ठ २०१
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×