Question
Use SQL for the following 1. Create table Student (ROLL_NO, SNAME, MATHS, CHEM, PHY) with appropriate date types for columns 2. Insert five rows into
Use SQL for the following
1. Create table Student (ROLL_NO, SNAME, MATHS, CHEM, PHY) with appropriate date types for columns
2. Insert five rows into the table Student.
3. Calculate the total of marks and add column TOTAL to Student table.
4. Set the values of TOTAL for each row.
5. Calculate the average of marks and add column AVERAGE to Student table.
6. Set the values of AVERAGE for each row.
Step by Step Solution
3.42 Rating (168 Votes )
There are 3 Steps involved in it
Step: 1
1 CREATE TABLE IF NOT EXISTS Student ROLLNO int11 NOT NULL AUTOINCREMENT SNAME varchar255 NO...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Practicing Statistics Guided Investigations For The Second Course
Authors: Shonda Kuiper, Jeff Sklar
1st Edition
321586018, 978-0321586018
