Dev.to

SQL Problem 1 — Matching Skills — Easy Solution

Running notes Tables we have - candidate | skill Question find candidates proficient in Python, Tableau, and PostgreSQL (ALL 3 SKILLS) Sort the output by candidate ID in ascending order Solution SELECT * FROM candidates; This has given me an overall view of the database, so i know how the dataset looks like SELECT * FROM candidates WHERE skill IN ('Python','Tableau','PostgreSQL'); This is now showing me all the candidates that have any one of these skills

Mar 3, 2025 - 18:48
 0
SQL Problem 1 — Matching Skills — Easy Solution

Running notes

Tables we have -

candidate | skill

Question

  1. find candidates proficient in Python, Tableau, and PostgreSQL (ALL 3 SKILLS)
  2. Sort the output by candidate ID in ascending order

Solution

SELECT * 
FROM candidates;

This has given me an overall view of the database, so i know how the dataset looks like

SELECT * 
FROM candidates
WHERE skill IN ('Python','Tableau','PostgreSQL');

This is now showing me all the candidates that have any one of these skills

Read More

Tags:

Previous Article

Protegendo suas API's com Keycloak

Next Article

Tiny URL Design

Related Posts

Everything Starts with Phantom: My First Step into Solana's World

Everything Starts with Phantom: My First Step into Sola...

Apr 5, 2025  0

Bookings Frontend

Bookings Frontend

Mar 30, 2025  0

5 Tips Devs/Admins, Excel Files in Apex, AI - Evolve or Be Replaced,

5 Tips Devs/Admins, Excel Files in Apex, AI - Evolve or...

Mar 25, 2025  0