No tienes acceso a esta clase

¡Continúa aprendiendo! Únete y comienza a potenciar tu carrera

# Playground: Filtrando Datos con WHERE

40/67

Aportes 63

Preguntas 0

Ordenar por:

¿Quieres ver más aportes, preguntas y respuestas de la comunidad?

Solución… 😄
.

.
.
.
.
.
.

``````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%";
``````

My solution:

``````SELECT *
FROM COURSES
WHERE n_reviews >= 1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE '%SQL%'
``````

Este Playground está descrito excelentemente bien. 😍 Si todos fueran como este, ahorráramos muchísimo tiempo. 🙃

Mi solución

``````
SELECT *
FROM COURSES WHERE n_reviews > 0;

SELECT *
FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;

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

``````

Increible! lo estoy entendiendo 🙃!

```js 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 COURSES WHERE n\_reviews BETWEEN 1 AND 100;SELECT \*FROM COURSESWHERE 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%%”;

Here we go 😃

``````SELECT *
FROM COURSES
where n_reviews > 80;
``````

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%’;

Mi respuesta:

``````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 >=1;
SELECT *
FROM COURSES
WHERE n_reviews >=1
AND n_reviews <=100;
SELECT *
FROM COURSES
WHERE name like ‘%SQL%’;

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

SELECT *
FROM COURSES WHERE n_reviews>=1 and n_reviews<=100

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES where name LIKE ‘%SQL%’

Hola muchachos acá esta mi solución

``````< SELECT *
FROM COURSES
WHERE n_reviews > 0;

SELECT *
FROM COURSES
WHERE n_reviews between 1 and 101;

SELECT *
FROM COURSES
WHERE name like "%SQL%";>
``````

yeeei

``````SELECT *
FROM COURSES
WHERE n_reviews > 0;

SELECT *
FROM COURSES
where n_reviews BETWEEN 1 AND 100;

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

Está bueno como este curso va de a poco, paso a paso, sin atropellar con lo que se aprende!

.
.
.
.
.
.
.
.
.
.
.
.
.
.

``````-- Selección de los cursos con al menos 1 review (n_reviews > 0)
SELECT id, name, n_reviews
FROM courses
WHERE n_reviews > 0;

-- Selección de los cursos con entre 1 y 100 reviews (n_reviews entre 1 y 100)
SELECT id, name, n_reviews
FROM courses
WHERE n_reviews BETWEEN 1 AND 100;

-- Selección de los cursos con "SQL" en alguna parte de su nombre (usando LIKE)
SELECT id, name, n_reviews
FROM courses
WHERE name LIKE '%SQL%';

``````

SELECT *
FROM COURSES
WHERE n_reviews >= 1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE ‘%SQL%’

O
2)
– Escribe tu código aquí 👇
SELECT *
FROM COURSES
WHERE n_reviews >= 1
and n_reviews between 1 and 100
and name like ‘%SQL%’
;

deberian agregar mas de estos cada vez que se ve un tema, es una dinamica muy genial.

Mi solucion:

SELECT *
FROM COURSES
WHERE n_reviews >=1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE ‘%SQL%’;

me gustan estos pequeños desafios, gracias platzi

``````-- Escribe tu código aquí 👇
-- SELECT * FROM COURSES;

SELECT *
FROM courses
WHERE n_reviews > 1;

SELECT *
FROM courses
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM courses
WHERE name LIKE '%SQL%';
``````

– 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%”;

``````SELECT * FROM courses
WHERE n_reviews >= 1;

SELECT * FROM courses
WHERE n_reviews BETWEEN 1 AND 100;

SELECT * FROM courses
WHERE name LIKE "%SQL%";
``````

– Mi solución 👇

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

``````-- 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%";
``````

## 40. Playground: Filtrando Datos con WHERE

``````-- Escribe tu código aquí 👇
SELECT id, name, n_reviews
FROM courses
WHERE n_reviews >= 1;

SELECT id, name, n_reviews
FROM courses
WHERE n_reviews BETWEEN 1 AND 100;

SELECT id, name, n_reviews
FROM courses
WHERE name LIKE '%SQL%';
``````

al fin pude realizar un reto 😃 la guia fue excelente en los anteriores me perdia en que objetivos se cumplirian

Otro reto más para la colección 😉💚

Aquí pueden probar el código:

``````-- Primer reto
SELECT *
FROM COURSES
WHERE n_reviews >= 1;

-- Segundo reto
SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

-- Tercer reto
SELECT *
FROM COURSES
WHERE name LIKE '%sql%';

``````

Solucion
.
Ejecutando el código:
.

.
Corriendo las pruebas:
.

Feedback (April 1st, 23): Las soluciones que escribimos no se guardan y los playground se consideran completos por el simple hecho de dar clic en avanzar y no cuando se escribe la solución.

### Comparto mi Solución 👇

``````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%";
``````

A quien le sirva, aqui mi solucion:

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

SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT * FROM COURSES
WHERE name LIKE '%SQL%'
``````

Buenas Clases, he disfrutado los playground.
No pongo mis respuestas porque es seguir la corriente del mundo.

SELECT *
FROM COURSES
WHERE n_reviews >=1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE ‘%SQL%’;

Mi solución:

``````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%';
``````

Mi solución está aquí:

``````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 COURSES
WHERE n_reviews > 0;

SELECT *
FROM COURSES
WHERE n_reviews > 0 AND n_reviews <= 100;

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

Mi solucion:
.
.
.
.
.
.
.
.

![](

Mi solucion :DD

``````-- Primera sentencia where

SELECT * from COURSES
where n_reviews >= 1;

-- Segunda sentencia where

SELECT * from COURSES
where n_reviews > 1 and n_reviews < 100;

-- Tercera sentencia where

SELECT * from COURSES
where name like '%SQL%'
``````

Solucion

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 COURSES
WHERE n_reviews >= 1;

SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

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

Comparto mi Query

``````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 COURSES
WHERE n_reviews >= 1;

SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

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

– Escribe tu código aquí 👇
.
.
.
.
.
.
.
.
.
– MI CODIGO

``````SELECT *
FROM COURSES
WHERE n_reviews > 1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

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

Esta fue mi solución

Este fue el código que usé

``````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%';
``````
``````SELECT * FROM COURSES
WHERE n_reviews >= 1;

SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT * FROM COURSES
WHERE name LIKE "%SQL%";
``````

Es la primera vez que me sale de una . que buena herramienta para practicar lo aprendido .

SELECT *
FROM COURSES
WHERE n_reviews >=1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE ‘%SQL%’;

Solución:

``````SELECT *
FROM courses
WHERE n_reviews>=1;

SELECT *
FROM courses
WHERE n_reviews>=1  AND n_reviews<=100;

SELECT *
FROM courses
WHERE name LIKE "%SQL%";
``````

Mi humilde solución.

````````
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 >=1;

SELECT *
FROM courses
WHERE n_reviews BETWEEN 1 AND 100;

SELECT
name
FROM courses
WHERE name LIKE '%SQL%';
``````
``````-- Escribe tu código aquí 👇
SELECT *
FROM COURSES where n_reviews >=1;

SELECT *
FROM COURSES where n_reviews BETWEEN 1 and 100;

SELECT *
FROM COURSES where name like '%SQL%'

``````
undefined