Who can help me solve this please?

Veve_1997 Posted messages 1 Status Membre -  
bendrop Posted messages 12655 Registration date   Status Contributeur Last intervention   -
```plsql
DECLARE
v_count NUMBER;
v_average_salary NUMBER;
BEGIN
SELECT COUNT(*), AVG(salary) INTO v_count, v_average_salary
FROM pilots
WHERE age BETWEEN 30 AND 40;

DBMS_OUTPUT.PUT_LINE('Nombre de pilotes : ' || v_count);
DBMS_OUTPUT.PUT_LINE('Salaire moyen : ' || v_average_salary);

FOR r IN (SELECT name, date_of_birth, salary
FROM pilots
WHERE age BETWEEN 30 AND 40)
LOOP
DBMS_OUTPUT.PUT_LINE('Nom : ' || r.name || ', Date de naissance : ' || r.date_of_birth || ', Salaire : ' || r.salary);
END LOOP;
END;
```

1 réponse

bendrop Posted messages 12655 Registration date   Status Contributeur Last intervention   8 524
 
1