Using the tables above write SQL commands to accomplish the following tasks:

• Display truck number; buy date, mileage, and serial number of all trucks.
• Display truck number, buy date, and mileage of all trucks with Dallas as their base
• Display truck number and buy date of all trucks with Dallas as their base and with mileage lower than 30,000 miles.

BASE BASENUM 501 502 TYPE TYPENUM BASECITY Dallas New York BASESTATE BASEPHONBASEMGR TX NY 893-9870 234-7689 J. Jones K. Lee TYPEDESC single box, double axle tandem trailer, single axle TRUCK TNUM 1001 1002 1003 1004 BASENUM 501 502 501 TYPENUMM TMILES 5900.2 64523.9 32116.0 3256.9 TBOUGHT 11/08/90 aa-125 11/08/90 09/29/91 01/14/92ac-315 TSERIAL 2 2 2 -213 -215