Show names of pilots that have more than one record.
CREATE TABLE pilot (
    Pilot_name VARCHAR,
    pilot_ID VARCHAR
)

CREATE TABLE pilot_record (
    pilot_ID VARCHAR
)
SELECT T2.Pilot_name, COUNT(*) FROM pilot_record AS T1 JOIN pilot AS T2 ON T1.pilot_ID = T2.pilot_ID GROUP BY T2.Pilot_name HAVING COUNT(*) > 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show names of pilots that have more than one record. ### Input: CREATE TABLE pilot (
    Pilot_name VARCHAR,
    pilot_ID VARCHAR
)

CREATE TABLE pilot_record (
    pilot_ID VARCHAR
) ### Response: SELECT T2.Pilot_name, COUNT(*) FROM pilot_record AS T1 JOIN pilot AS T2 ON T1.pilot_ID = T2.pilot_ID GROUP BY T2.Pilot_name HAVING COUNT(*) > 1