I need help creating an SQL data table with at least 5 fields per record (not co

Question

I need help creating an SQL data table with at least 5 fields per record (not counting ID) and at least 20 records. It should be data about video games. What game it is, when it was released, what series is it apart of, what genre is it, etc. I tried doing this on my own but I don't know how to insert spaces between two strings in SQL. Will rate thumbs up. Paste the code that creates the table, as well as the contents that go inside of the table. Do not use a golden templete as I do not have Windows Excel.

Explanation / Answer

CREATE TABLE videoGame(
id int,
game_name varchar(100),
genre varchar(50),
release_date datetime,
partofseries varchar(100),
version varchar(10),   
PRIMARY KEY(id)
);

INSERT INTO videoGame(id,game_name,genre,release_date,partofseries,version)
VALUES(1,'need for speed','racing',getdate(),'nfs','5.0.0.1')

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.