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.
Hi, do you have a day for the same. This seems pretty simple, but if some time is there then can get everything perfect. From what is there, currently it seems simple create database... then create two tables and then using select from ...inner join
Almost forgotten, but if half a day is there to go through can get it all well in a day's time. Let me know your opinion and time restriction that you have. Thank you.
$10 USD en 1 día
5,0 (5 comentarios)
2,6
2,6
15 freelancers están ofertando un promedio de $13 USD por este trabajo
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done many MYSQL/SQL projects here on Freelancer.com and i've never had a single problem. If you are interested, please message me and i will try to finish this exercise as fast as i can. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect.
Thanks, Milan
Hello, read your description and want you to know that i've been into development for almost 3 years with numerous projects in portfolio in which sql is the major part. I've worked in sql scripts as well for few of my projects. I'm very much sure on my skills and assure you complete satisfaction by the quality of work. We can discuss further details in chat.
Thank You
kind regards,
Faizan Ahmed
Give me a chance, and I won't disappoint you. I have expertise building SQL queries. No lies, no bullshit, and you pay me only after the work is done.
I'm new here, so I will appreciate a feedback
I'am a new freelancer but I have work several company and working with SQL all the times. So I think your request will be done successfully and on time. I look forward to hearing from you
Hello, I would be happy to do this SQL Script for you.
I've been working with SQL's for more than 5 years now and based from the requirements you've posted, it can easily be done. Please let me know if you have any questions as I'd be happy to answer them for you.
Thank you,
Zed