SQL Interactive Learning Tool

Data Table - company.employees

    
    
    Employee Table
    


    
        
            id
            first_name
            job_title
            department_id
            salary
            vacation_days
            birthday
        

            101
            Frank
            Manager 2
            3
            123000
            5
            3/15/1994 00:00:00
        

            213
            Jane
            Developer
            2
            135000
            2
            6/14/1980 00:00:00
        

            279
            Ashley
            Manager 2
            3
            140000
            3
            12/5/1975 00:00:00
        

            401
            Glenn
            NULL
            NULL
            115000
            -3
            3/23/1988 00:00:00
        

            405
            Kelly
            Developer
            2
            125000
            2
            10/11/1979 00:00:00
        

            417
            Richard
            Business Operations
            1
            120000
            -7
            8/30/1985 00:00:00
        

            563
            George
            Sales Representative
            1
            105000
            2
            2/18/1992 00:00:00
        

            680
            Kyle
            Security
            5
            200000
            1
            4/7/1983 00:00:00
        

            881
            James
            Developer
            2
            107000
            -2
            9/27/1978 00:00:00
        

            908
            Gustavo
            Accountant
            1
            100000
            -10
            11/21/1987 00:00:00
        

id	first_name	job_title	department_id	salary	vacation_days	birthday
101	Frank	Manager 2	3	123000	5	3/15/1994 00:00:00
213	Jane	Developer	2	135000	2	6/14/1980 00:00:00
279	Ashley	Manager 2	3	140000	3	12/5/1975 00:00:00
401	Glenn	NULL	NULL	115000	-3	3/23/1988 00:00:00
405	Kelly	Developer	2	125000	2	10/11/1979 00:00:00
417	Richard	Business Operations	1	120000	-7	8/30/1985 00:00:00
563	George	Sales Representative	1	105000	2	2/18/1992 00:00:00
680	Kyle	Security	5	200000	1	4/7/1983 00:00:00
881	James	Developer	2	107000	-2	9/27/1978 00:00:00
908	Gustavo	Accountant	1	100000	-10	11/21/1987 00:00:00

Query Input

SQL Learning Widget

Aggregate Functions:

String Functions:

Numeric Functions:

Date and Time Functions:

Ranking Functions:

Note: When using functions in this section, the original data will be sorted, so if you run any other functions after, the order wont match the dataset above anymore, refresh the page if you wish to test out other functions while matching the data order above.