@jullan4205

CREATE TABLE Instructors( InstructorID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Email VARCHAR(100), Phone VARCHAR(20) ); INSERT INTO Instructors VALUES (1, "Sahra", "Adams", "sahra.adams@email.com", "555-

CREATE TABLE Author( AuthorID INT PRIMARY KEY, AuthorName VARCHAR(100), BirthYear INT, Nationality VARCHAR(50) ); INSERT INTO Author VALUES (1, "Mark Twain", 1835, "American"), (2, "Jane Austin", 1777, "British"), (3, "Ge

-- student table -- primary key: id -- first name, last name (50 characters), birthdate, age, -- completed_math_course (boolean) CREATE TABLE student( student_id INT PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR(50), last_name VARCHAR(

CREATE TABLE student ( StudentID INT PRIMARY KEY, student_name VARCHAR(100), age INT, grade VARCHAR(100) ); INSERT INTO student VALUES (1, "John", 18, "C+"), (3, "Luke", 22, "A+"), (6, "Peter", 20, "B-");

-- student table -- primary key: id -- first name, last name (50 characters), birthdate, age, -- completed_math_course (boolean) CREATE TABLE student( student_id INT PRIMARY KEY AUTO_INCREMENT, first_name VARCHAR(50), last_name VARCHAR(

-- Create a Student table with four columns like student_id, name, subject and marks. -- Enter the details of 5 students on above Student table using the Insert command CREATE TABLE Student( student_id INT, name TEXT, subject TEXT,

CREATE TABLE Books( book_id INT, title TEXT, author TEXT, genre TEXT, year_published INT ); -- DESC Books; INSERT INTO Books VALUES( 1, "Harry Potter", "J.K. Rowling", "Fantasy", 1997),