Write SQL commands for the following: …

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

What is complex literal?how will you write a complex value explain with an example

Define pretty printing.

Write a program to input 6 digit number and divide it into three 2 digit number

Case study based question

what is palindrone

write a program to input names of 5 employees and store them in a list.now enter name of an employees and find if this employee is present in the list or not.

Convert the following numbers system (10011111)2=(?)16=(?)10=(?)8

(A) it is possible to have a duplicate keys in python dictionary (R)If u attempt to add a new key value pair with a key that already exists in the dictionary,the value Associated with existing key will be overwritten with the new value

Write a program to input 5 subject names and put it in tuble at display that tupper information on the output screen

What is the machine leaning