SQL JOINS

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