Find Jobs
Hire Freelancers

Simple SQL script

$10 USD

Terminado
Publicado hace alrededor de 7 años

$10 USD

Pagado a la entrega
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.
ID del proyecto: 13293007

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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
Avatar del usuario
Can create the db within 1-2 hours......waiting for your reply.....thanks....n u can pay me after the work done...
$13 USD en 1 día
5,0 (5 comentarios)
3,7
3,7
Avatar del usuario
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
$14 USD en 0 día
5,0 (13 comentarios)
3,2
3,2
Avatar del usuario
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
$11 USD en 0 día
4,7 (2 comentarios)
1,2
1,2
Avatar del usuario
I understand your requirements for the job and I think I will be able to do it efficiently as I have previously worked with SQL, Database development
$10 USD en 1 día
5,0 (1 comentario)
0,5
0,5
Avatar del usuario
I working with MS SQL , MySql over 3 and i know how write good sql script. It is simple script for me.
$12 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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
$13 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
New York, United States
5,0
22
Forma de pago verificada
Miembro desde jul 8, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.