SELECT EXTRACT(YEAR FROM c.date_consult) AS annee, EXTRACT(MONTH FROM c.date_consult) AS mois,p.signature as medecin, COUNT(c.id_unique) AS nombre_de_consultation, sum(r.montant_euro) as montant
FROM consultations c, parametres p, recettes r
WHERE c.date_consult BETWEEN '2022-10-01' AND '2025-10-30' AND c.rid_utilisateur = p.id_unique AND r.id_praticien = p.id_unique
GROUP BY EXTRACT(YEAR FROM c.date_consult), EXTRACT(MONTH FROM c.date_consult),r.annee, r.mois, p.signature
ORDER BY annee, mois,r.annee, r.mois, p.signature

select extract(year from date) as annee, extract(month from date) as mois, count(*) as nombre_d_iteraration 
from table_test 
group by date 
order by date

COD_NOLIST  |  COD_CODE  |  COD_LIBELLE
1                   |  1                 |  Libellé 1
1                   |  2                 |  Libellé 2
1                   |  3                 |  Libellé 3
2                   |  1                 |  Libellé 4
2                   |  2                 |  Libellé 5

DO
$DO$
DECLARE
	myvalues varchar[] := ARRAY['value1', 'value2', 'value3', 'value4'];
    e varchar;
BEGIN
FOREACH e SLICE 0 IN ARRAY myvalues
LOOP
    INSERT INTO ana (ana_cecn, ana_ccat, ana_cmet, ana_crsp)
	VALUES
	(
	SELECT ecn_cecn FROM ecn WHERE ecn_ref_aut = e,
	SELECT acat_ccat FROM ana_cat WHERE acat_type = 'acat_type',
	SELECT amet_cmet FROM ana_met WHERE amet_lib_fre = 'lib_fre',
	SELECT rsp_crsp FROM rsp WHERE rsp_nom = 'my_rsp_nom'
	);
END LOOP;
END;
$DO$;

ERROR:  erreur de syntaxe sur ou près de « SELECT »
LINE 13:  SELECT ecn_cecn FROM ecn WHERE ecn_ref_aut = e,
          ^ 
 
ERREUR:  erreur de syntaxe sur ou près de « SELECT »
SQL state: 42601
Character: 253

CREATE TABLE JUR (
	jur_code			VARCHAR(5)		PRIMARY KEY,
	jur_code_father		VARCHAR(5)		,
	jur_label_eng		VARCHAR(50)		NOT NULL,
	jur_label_fre		VARCHAR(50)		,
	jur_comment			VARCHAR(2000)	,
	CONSTRAINT fk_jur_code_father FOREIGN KEY(jur_code_father) REFERENCES JUR(jur_code)
);

INSERT INTO JUR (jur_code, jur_code_father, jur_label_eng, jur_label_fre, jur_comment)
VALUES
("A", null, "Maritime zone", "Zone maritime", "Classification established in the Law Of The Sea : Internal Waters, Territorial Sea, Contiguous Zone, Exclusive Economic Zone, Continental Shelf, High Seas & Deep Ocean Floor")
;

NOTICE:  l'identifiant « Classification established in the Law Of The Sea : Internal Waters, Territorial Sea, Contiguous Zone, Exclusive Economic Zone, Continental Shelf, High Seas & Deep Ocean Floor » sera tronqué en « Classification established in the Law Of The Sea : Internal Wat »
 
ERROR:  la colonne « A » n'existe pas
LINE 3: ("A", null, "Maritime zone", "Zone maritime", "Classificatio...
         ^ 
 
ERREUR:  la colonne « A » n'existe pas
SQL state: 42703
Character: 96

START TRANSACTION;
SET @dossier_id := 206879; DELETE FROM pretemporaire WHERE id_dossier = @dossier_id; 
DELETE FROM mactist WHERE dossier_id = @dossier_id; 
update mactist set volu1 ='10' where do_id = @dossier_id; 
COMMIT;

select 1 / case when LeNombre > 10000 then 0 else 1 end 
from LaTable

select 1 / case when isnull(disk_usage_pct,0) > 40 then 0 else 1 end as control_value
from svv_schema_quota_state

return await new Promise(function (resolve, reject) {
        pool_bdca.query("SELECT i.id, priorite, ip.nom AS priorite_nom, \
                                date(date_piece_na) AS date_piece_na, date(date_reception_ca) AS date_reception_ca, \
                         FROM matable i, 
                         (error, results) => {
        if (error) {
          reject(error);
        }
        if (results && results.rows) {
          resolve(results.rows);
        } else {
          reject(new Error("No results found"));
        }
      });
    });
  } catch (error_1) {
    throw new Error("Internal server error", {cause: error_1});
  }