Student Activity Record Instructions
Uploaded by
kamranftp09Student Activity Record Instructions
Uploaded by
kamranftp09Common questions
Powered by AICompiling a complete report involves writing each activity on A4 paper with the code on the right and output on the left. SQL queries to be included can involve displaying sports-wise total medals (e.g., `SELECT sport, COUNT(medal) AS total_medals FROM athletes GROUP BY sport;`), displaying uppercase names (e.g., `SELECT UPPER(name) FROM athletes WHERE country = 'India';`), and other tasks as instructed. Ensure proper documentation and order before binding. Submission date adherence is critical .
To display the names of all Indian athletes in uppercase, you can use the SQL query: `SELECT UPPER(name) FROM athletes WHERE country = 'India';` .
Students are instructed to write activities on A4 size blank paper, with code on the right side and output on the left side. They must design a front page and certificate, do spiral binding, and submit by the due date, 09.09.2025 .
Removing leading and trailing spaces is crucial for ensuring data consistency and preventing issues with data retrieval and reporting. In SQL, leading and trailing spaces can be removed using the command: `SELECT TRIM(email) FROM Students;` This cleans up data by ensuring uniformity and accuracy in data entries .
To calculate the remainder when 125 is divided by 8, you can use the SQL command: `SELECT 125 % 8;` The result will be `5` .
To display the first five characters from 'Informatics Practices', use the SQL command: `SELECT SUBSTRING('Informatics Practices', 1, 5);` The result is `Infor` .
To display athlete names starting with 'A', use the SQL query: `SELECT name FROM athletes WHERE name LIKE 'A%';` This query is used to filter and retrieve records of athletes whose names begin with 'A', aiding in sorting and organizing data .
To display the sports-wise total number of medals won, you can use the SQL query: `SELECT sport, COUNT(medal) AS total_medals FROM athletes GROUP BY sport;` .
To round the value of pi (3.14159) to two decimal places, you can use the SQL command: `SELECT ROUND(3.14159, 2);` The expected result is `3.14` .
To display the number of characters in 'NewDelhi', use the SQL function: `SELECT LENGTH('NewDelhi');` The expected output is `8` .