-
Navegar entre proyectos:
Ctrl+r
- Cambiar de terminal.
Focus en terminal
osoda
/ Shortcuts VSCode.md
Last active
May 3, 2023 17:43
Shortcuts VSCode Para trabajar en la terminall
osoda
/ solution-queo-backend-challenge.sql
Last active
December 10, 2024 06:50
Solution to the Queo Backend Challenge
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # NOTE: We need disable the ONLY_FULL_GROUP_BY mode | |
| SET SESSION sql_mode=(SELECT replace(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''),'NO_ENGINE_SUBSTITUTION','')); | |
| select count(1) cant from ( | |
| SELECT e.*, s.name , s2.code, group_concat(s2.code) codeVal, COUNT(s.name) cant | |
| from enrollment e | |
| inner join student s on e.student_id =s.id | |
| inner join `group` g on e.group_id = g.id | |
| left join subject s2 on g.subject_id =s2.id and right(s2.code,1) = '1' |
OlderNewer