8. Create a table named "Students" with the following columns: StudentID (integer) FirstName (varchar.maximum length 50) LastName (varchar maximum length 50) BirthDate (date) Major (varchar maximum length 100) 9. Insert two sample rows into the "Students" table with diverse information. fort Name last Nam 10. Write a query to add a new column named "Nationality" with a data type of VARCHAR (20) to the "Students "table.

Question

8. Create a table named "Students" with the following columns: StudentID (integer) FirstName (varchar.maximum length 50) LastName (varchar maximum length 50) BirthDate (date) Major (varchar maximum length 100) 9. Insert two sample rows into the "Students" table with diverse information. fort Name last Nam 10. Write a query to add a new column named "Nationality" with a data type of VARCHAR (20) to the "Students "table.

Answer 1

8. Here is the SQL code to create the "Students" table with the specified columns:```sqlCREATE TABLE Students ( StudentID INT, FirstName VARCHAR(50), LastName VARCHAR(50), BirthDate DATE, Major VARCHAR(100));```9. Here is the SQL code to insert two sample rows into the "Students" table:```sqlINSERT INTO Students (StudentID, FirstName, LastName, BirthDate, Major)VALUES (1, 'John', 'Doe', '1990-01-01', 'Computer Science'), (2, 'Jane', 'Smith', '1995-05-05', 'Biology');```10. Here is the SQL code to add a new column named "Nationality" with a data type of VARCHAR(20) to the "Students" table:```sqlALTER TABLE StudentsADD Nationality VARCHAR(20);```

Soru

Çözüm

Cevap