Ülesanne 5-Andmetabeli toomine varundusfailist-erinevad päringud
Väljasta
nimi ja kaal.
mysql> SELECT L_nimi, Synnikaal FROM SYNNID WHERE Synnikaal<=3800;
+-----------+-----------+
| L_nimi | Synnikaal |
+-----------+-----------+
| Richard | 2385 |
| Ralf | 3736 |
| Karolin | 3538 |
| Liisi | 2920 |
| Kaur | 2610 |
| Rasmus | 2462 |
| Ramona | 2473 |
| Otto | 3148 |
| Konrad | 2652 |
| Karola | 3545 |
| Sten | 3740 |
| Heike | 3450 |
| Aneteliis | 3290 |
| Kelly | 3250 |
| Sander | 3330 |
| Marten | 3756 |
| Bairon | 2710 |
| Inga | 3056 |
| Sebastian | 2818 |
| Jaan | 3496 |
| Elis | 2760 |
| Heleriin | 3398 |
| Melani | 3150 |
| Joosep | 3460 |
| Kaidro | 3670 |
| Rasmus | 3670 |
| Jessika | 3670 |
| Prank | 3166 |
| Lars | 3090 |
| Oliver | 3640 |
| Kelli | 3540 |
annaabi.ee 
