27. Insert the following information: Students …

27. Insert the following information: Students Adno Name Average *** 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 28. Write queries based upon item table given in q. no 27. (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 ***. (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. 200

What are called tokens

Differentiate between function and argument

1.1. In a table in MYSQL database, an attribute A of datatype varchar(20) Nes the value "Keshar The attribute S of datatype char(20) has value "Meenakshi". How many characters are occupied by attribute A and attribute 67 a. 20,6 6.6,20 ८. 9,6 d. 6,9

What is mean by buffering in file handling?

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

• Don't post personal information, mobile numbers and other details.
• Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
• Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
• Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

WeaLthSnaP loAn cUsToMeR care number +91) 8016603152-@8961101473

Write a program in python to accept a number and check whether the number is divisible by 3 as well as 5 otherwise decide : (a) Is the number divisible by 3 and not by 5 (b) is the number divisible by 5 and not by 3 (c) is the number neither divisible by 3 or by 5

A Railway company uses machines to sell tickets. The machine details and daily sales information are recorded in two tables: Table Name: Machine Table Name: Sales The primary key of the table Machine is Machine_ID. Records in the table Sales are uniquely identified by the fields Machine_ID and Date. (a) Create the tables Machine and Sales. (b) Write a query to find the number of ticket machines in each station. (c) Write a query to find the total ticket income of the station “New Delhi” of each day. (d) Write a query to find the total number of tickets sold by the machine (Machine_ID = 122) till date.

Your school has a document enlisting names of school students who have pass this year and taken admission in further courses. You have to edit the documents with the following changes: a) Find the word ‘utilitarian‘ and replace it with the word ‘pragmatic’ (Take care not to replace the word utilitarianism). b) The word college as it occurs in the text should be capitalize. Replace the word college with the correct capitalization i.e with College throughout the text using the appropriate option.

Which book do you all follow for cs? How many chapters are there in the syllabus