Who can help me solve this please?
Veve_1997
Posted messages
1
Status
Membre
-
bendrop Posted messages 12655 Registration date Status Contributeur Last intervention -
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;
```
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
Hello,
Some advice https://www.commentcamarche.net/infos/25857-charte-de-commentcamarche-net-conseils-d-ecriture/
https://www.commentcamarche.net/infos/25855-charte-d-utilisation-de-commentcamarche-net-respect-d-autrui/
As well as https://www.commentcamarche.net/infos/25899-demander-de-l-aide-pour-vos-exercices-sur-ccm/
If you do not follow them, your request will remain unanswered.
Best regards.
--
Ignorance and folly have their pleasures just as the mind and knowledge do.
Some advice https://www.commentcamarche.net/infos/25857-charte-de-commentcamarche-net-conseils-d-ecriture/
https://www.commentcamarche.net/infos/25855-charte-d-utilisation-de-commentcamarche-net-respect-d-autrui/
As well as https://www.commentcamarche.net/infos/25899-demander-de-l-aide-pour-vos-exercices-sur-ccm/
If you do not follow them, your request will remain unanswered.
Best regards.
--
Ignorance and folly have their pleasures just as the mind and knowledge do.