of rows in a table. • SUM() function retrieves the sum of a selected column of rows in a table. • MAX() function returns the largest value of the selected column. • MIN() function returns the smallest value of the selected column • is the master table which holds the key information about your database tables.
• The path of a file can be either represented as ‘/’ or using ‘\’ in Python. For example the path can be specified either as 'c:/pyprg/sql.csv', or c:\pyprg\sql.csv’. Points to remember: 12th Computer Chapter - - Data Manipulation Through SQL Hands on Experience . Create an interactive program to accept the details from user and store it in a csv file using Python for the following table.
Database name;- DB1 Table name : Customer Address City C008 Sandeep / Pritam Pura 41206819 Delhi C010 Anurag Basu 15A, Park Road 61281921 Kolkata C012 Hrithik / Vasant Nagar 26121949 Delhi . Consider the following table GAMES. Write a python program to display the records for question (i) to (v) Table: GAMES Gcode Name GameName Number PrizeMoney ScheduleDate Padmaja Carom Board - - Vidhya Badminton 12000 - - Guru Table Tennis - - Keerthana Carom Board - - Krishna Table Tennis 25000 - - (i) To display the name of all Games with their Gcodes in descending order of their schedule date. (ii) To display details of those games which are having Prize Money more than .
(iii) To display the name and gamename of the Players in the ascending order of Gamename. (iv) To display sum of PrizeMoney for each of the Numberof participation groupings (as shown in column Number ) (v) Display all the records based on GameName 12th Computer Chapter - -