Font size
WorksheetsSQL JOINS
Total questions: 10
Worksheet time: 23mins
Seleccione sentencia para listar todos los registros en los cuales num_books_read es mayor a 185
SELECT * from family_members WHERE num_books_read > 185
SELECT * family_members WHERE num_books_read > 185
SELECT * from family_members WHERE num_books_read = 185
SELECT * from family_members WHERE num_books_read >= 185
Complete la sentencia para agregar FK iddepartamento a la tabla usuarios: ALTER TABLE usuarios ___ usuarios_fk ___ REFERENCES departamentos(id)
(a)
Seleccione sentencia para listar todos los perros con menos de 50 cm
select * from friends_of_pickles where species='dog' and height_cm > 45
select * from friends_of_pickles where species='dog' and height_cm < 45
select * from friends_of_pickles where height_cm < 45
select * from friends_of_pickles species='dog' and height_cm < 45
Seleccione sentencia para listar el promedio de estatura por género
select gender, avg(height_cm) promedio from friends_of_pickles group by height_cm
select gender, sum(height_cm) promedio from friends_of_pickles group by gender
select gender, avg(height_cm) promedio from friends_of_pickles group by gender
select height_cm, avg(height_cm) promedio from friends_of_pickles group by gender
Seleccione sentencia para listos los registros que sean perros o que la estatura sea inferior a 45
SELECT * FROM friends_of_pickles WHERE height_cm <45
SELECT * FROM friends_of_pickles WHERE height_cm >45 OR species = 'dog'
SELECT * FROM friends_of_pickles WHERE height_cm <45 AND species = 'dog'
SELECT * FROM friends_of_pickles WHERE height_cm <45 OR species = 'dog'
Complete la senencia para listar la cantidad de perror que hay en la tabla:
select ___ ___ friends_of_pickles where species ___
(a)
Complete la sentencia para listar la máxima y mínima estatura: SELECT ___ ___ FROM friends_of_pickles
(a)
Seleccione sentencia para listar nombre de personaje y nombre de actor
select character.name, character_actor.actor_name from character
inner join character_actor
on character.id = character_actor.character_id
select character.name, character_actor.actor_name from character
inner join character_actor
on character.id = character_tv_show.character_id
select character.name, character.actor_name from character
inner join character_actor
on character.id = character_tv_show.character_id
select character.name, character_actor.actor_name from character
inner join character_actor
on character.id = character.id
Seleccione sentencia para listar nombre personaje y nombre de la serie
select character.name, character_tv_show.tv_show_name from
character inner join character_tv_show
on character.id= character_tv_show.character_id
select character_tv_show.name, character_tv_show.tv_show_name from
character inner join character_tv_show
on character.id= character_tv_show.character_id
select character.name, character_tv_show.tv_show_name from
character inner join character_tv_show
on character.id= character.character_id
select character.name, character_tv_show.tv_show_name from
character inner join character_tv_show
on character_tv_show.id= character_tv_show.character_id
Seleccione sentencia para listar nombre del personaje y nombre de la serie
select character.name, tv_show.name from character_tv_show inner join character on character.id=character_tv_show .character_id inner join tv_show on tv_show.id=character_tv_show .tv_show_id
select character.name, tv_show.name from character inner join character on character.id=character_tv_show.character_id inner join tv_show on tv_show.id=character_tv_show.tv_show_id
select character.name, tv_show.name from tv_show inner join character on character.id=character_tv_show.character_id inner join tv_show on tv_show.id=character_tv_show.tv_show_id
