Práctica: Filtrar Datos con WHERE en SQL

Clase 17 de 36 • Curso de Bases de Datos con SQL - Deprecado

Clase anteriorSiguiente clase

Juliana Castillo Araujo

Team Platzi•

Que increible prueba, la he realizado asi:

SELECT *

FROM COURSES

WHERE n_reviews > 0;

SELECT *

FROM COURSES

WHERE n_reviews BETWEEN 1 AND 100;

SELECT name

FROM COURSES

WHERE name LIKE "%SQL%";

Roberto Vargas Castro

student•

-- Escribe tu código aquí 👇

SELECT *

FROM COURSES

WHERE n_reviews > 0;

SELECT *

FROM COURSES

WHERE n_reviews BETWEEN 1 AND 100;

SELECT *

FROM COURSES

WHERE name LIKE "%SQL%";

Luis Fernando García de los Santos

student•

SELECT * FROM COURSES
WHERE n_reviews >= 1;

SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT name FROM COURSES
WHERE name like '%sql%'

Gabriel Maxemin

student•

-- Escribe tu código aquí 👇
SELECT * FROM COURSES
WHERE n_reviews >=  1;

SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT name FROM COURSES
WHERE name LIKE '%SQL%';

Angelina Jiménez

student•

Alberto Delgado Arciniegas

student•

No me carga la practica 09/11/2024

500 Internal Server Error

JulianFranchesco rp

student•

a veces sale ese error, yo trabajo desde una parcela solo con datos moviles, entonces dale que atras en la flechita al lado izquierdo de siguiente clase y de nuevo hacia siguiente clase y ahi carga.

Andres Camilo Morales Correa

student•

SELECT *FROM COURSES

where n_reviews >0;

SELECT *FROM COURSES

where n_reviews between 1 and 100;

SELECT NAME FROM COURSES

WHERE NAME LIKE '%SQL%';

CESAR PEREZ

student•

Comparto la respuesta:

SELECT *FROM COURSESWHERE n_reviews >=1; SELECT *FROM COURSESWHERE n_reviews between 1 and 100; SELECT *FROM COURSESWHERE name like '%SQL%';

Jhorman Salazar

student•

SELECT * FROM COURSES WHERE n_reviews > 1;SELECT * FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;SELECT * FROM COURSES WHERE name LIKE '%SQL%';

Omar Zamudio

student•

Griselda Merino

student•

-- Escribe tu código aquí 👇SELECT *FROM COURSESwhere n_reviews>0; SELECT *FROM COURSESwhere n_reviewsbetween 1 and 100; SELECT *FROM COURSESwhere name like '%SQL%';

Wilmar Carrillo

student•

CESAR PEREZ

student•

mi aporte:

SELECT *FROM COURSESWHERE N_REVIEWS >=1; SELECT *FROM COURSESWHERE N_REVIEWS BETWEEN 1 AND 100; SELECT *FROM COURSESWHERE NAME LIKE '%SQL%';

CESAR PEREZ

student•

Acá dejo mi aporte:

SELECT *
FROM COURSES
WHERE N_REVIEWS >=1;

SELECT *
FROM COURSES
WHERE N_REVIEWS BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE NAME LIKE '%SQL%';

```SELECT \*FROM COURSESWHERE N\_REVIEWS >=1;
SELECT \*FROM COURSESWHERE N\_REVIEWS BETWEEN 1 AND 100;
SELECT \*FROM COURSESWHERE NAME LIKE '%SQL%';

jesus manuel vergara arias

student•

Mi solución, aunque no fue tan sencillo llegar a ella:

SELECT * FROM COURSES WHERE  n_reviews > 0;
SELECT * FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;
SELECT * FROM COURSES WHERE name LIKE '%SQL%';

```SELECT \* FROM COURSES WHERE  n\_reviews > 0;SELECT \* FROM COURSES WHERE n\_reviews BETWEEN 1 AND 100;SELECT \* FROM COURSES WHERE name LIKE '%SQL%';

Brandon Argel Verdeja Domínguez

student•

-- Escribe tu código aquí 👇SELECT * FROM COURSESWHERE N_REVIEWS > 0; SELECT * FROM COURSESWHERE N_REVIEWS BETWEEN 1 AND 100; SELECT name FROM COURSESWHERE name LIKE "%SQL%";

Bastian Maurico Landskron Silva

student•

-- Seleccionar todos los cursos con al menos 1 reviewSELECT * FROM courses WHERE n_reviews >= 1;-- Seleccionar todos los cursos con entre 1 y 100 reviewsSELECT * FROM courses WHERE n_reviews BETWEEN 1 AND 100;-- Seleccionar los nombres de los cursos que contienen "SQL"SELECT name FROM courses WHERE name LIKE '%SQL%';

sebastian cuellar

student•

SELECT * FROM COURSES where n_reviews >= 1; SELECT * FROM COURSES where n_reviews between 1 and 100; SELECT name from COURSESwhere name like '%sql%';

Chanel M. Paredes Sánchez

student•

SELECT *

FROM COURSES

WHERE n_reviews != 0;

SELECT * FROM COURSES

WHERE n_reviews BETWEEN 1 and 100;

SELECT name FROM COURSES

WHERE name LIKE '%SQL%';

Isaac Bryan Ascanoa Roncall

student•

Me gusto este ejercicio. Aqui les muestro mi respuesta:

-- Escribe tu código aquí 👇SELECT *FROM COURSESWHERE n_reviews > 0; SELECT * FROM COURSESWHERE n_reviews BETWEEN 1 AND 100; SELECT name FROM COURSESWHERE name LIKE '%SQL%';```js -- Escribe tu código aquí 👇 SELECT * FROM COURSES WHERE n_reviews > 0;

SELECT * FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;

SELECT name FROM COURSES WHERE name LIKE '%SQL%';

Felipe Castro

student•

-- Escribe tu código aquí 👇SELECT * FROM COURSESWHERE n_reviews >=1; SELECT * FROM COURSESWHERE n_reviews BETWEEN 1 AND 100; SELECT name FROM COURSES WHERE name LIKE "%SQL%";