Get the payment number and the year of each penalty paid after 1980. : Year « Date Time « SQL / MySQL

1. SQL / MySQL
2. Date Time
3. Year

Get the payment number and the year of each penalty paid after 1980.

     
mysql>
mysql> CREATE TABLE PENALTIES(
    ->     PAYMENTNO INTEGER NOT NULL,
    ->     PLAYERNO INTEGER NOT NULL,
    ->     PAYMENT_DATE DATE NOT NULL,
    ->     AMOUNT DECIMAL(7,2) NOT NULL,
    ->     PRIMARY KEY (PAYMENTNO)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql>
mysql> INSERT INTO PENALTIES VALUES (1, 6, '1980-12-08', 100);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO PENALTIES VALUES (2, 44, '1981-05-05', 75);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql>
mysql> SELECT PAYMENTNO, YEAR(PAYMENT_DATE)
    -> FROM PENALTIES
    -> WHERE YEAR(PAYMENT_DATE) > 1980;
+-----------+--------------------+
| PAYMENTNO | YEAR(PAYMENT_DATE) |
+-----------+--------------------+
|         2 |               1981 |
+-----------+--------------------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql> drop table penalties;
Query OK, 0 rows affected (0.00 sec)

   
    
    
    
    
  

Related examples in the same category