(Solved) : Create Table Studentgrade Following Fields Regno Name Mark1 Mark2 Mark3 Create Primary Key Q31677476 . . . .

Create a table student_grade having following fields.
regno, name, mark1, mark2, mark3. Create a primary key onregno.
Use appropriate data type to describe each field.
If a student is absent for a subject the corresponding field isnull.
Insert 5 values into the student_grade table.
1. Write a query that will display regno,name, result where eachcolumn value should be displayed of 20 character, if the value isless than of 20 character right pad regno, left pad name with ‘*’and left pad total with ‘#’.
2. Display the details of all students with 5 letter names.
3. Concatenate student name and regno separated by a ‘,’ thestudent name should