Cancelled

Create single simple SQL script

In a single SQL script, with comments, follow these steps:

1. Create a new database (schema) called "Video_Reviews".

2. On the newly created schema, create one table to keep track of the videos. This table should include a unique ID, the title of the video, the length in minutes, and the URL. Populate the table with at least three related videos from YouTube, the Microsoft Power BI site, or other publicly available resources.

2. Create a second table that provides at least two user reviews for each of at least two of the videos. These should be imaginary reviews that include columns for the user’s name (“Luis”, “Sonya”, etc.), the rating (which could be NULL, or a number between 0 and 5), and a short text review (“Loved it!”). There should be a column that links back to the ID column in the table of videos.

3. Write a JOIN statement that shows information from both tables.

Please note that creating the table and inserting records on each table must be done in SQL. Do not insert records using the MySQL interface, or from a CSV file (or any other file). All work must be performed as a SQL script.

Skills: Database Programming, MySQL, SQL

See more: sql script to create database and tables, sql server generate create table script programmatically, sql server generate scripts with data, create table sql, sql server create database script, sql script tutorial, how to generate create table script for all tables in sql server database, how to get table script in sql server using query, cms class sql script create php simple page, simple sql script insert, create tables using sql script, how to create a secure login script in php and mysql, how to create a simple mvc framework in php, how to create a simple contact form in html, how to create a simple form plugin in wordpress, how to get create table script in sql developer, how to get create table script in oracle sql developer, how to run sql script in sql server 2012 management studio, edit sql script in crystal report, how to schedule sql script in crontab

About the Employer:
( 0 reviews ) Astoria, United States

Project ID: #18852925

2 freelancers are bidding on average $16 for this job

catstevens2009

Hi there! Have done this type of work before and am an SQL expert! Please feel free to message me with additional information or with questions if any, thanks! -Steve

$18 USD in 0 days
(9 Reviews)
4.2
mws2018

Hi Thanks for the response I have read the details and i can do that in less than a day Open project message board for further communication Best regards anwar

$14 USD in 1 day
(1 Review)
0.0