Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE affiliated_with ( physician number, department number, primaryaffiliation boolean )
TABLE: CREATE TABLE procedures ( code number, name text, cost number )
TABLE: CREATE TABLE on_call ( nurse number, blockfloor number, blockcode number, oncallstart time, oncallend time )
TABLE: CREATE TABLE stay ( stayid number, patient number, room number, staystart time, stayend time )
TABLE: CREATE TABLE room ( roomnumber number, roomtype text, blockfloor number, blockcode number, unavailable boolean )
TABLE: CREATE TABLE undergoes ( patient number, procedures number, stay number, dateundergoes time, physician number, assistingnurse number )
TABLE: CREATE TABLE block ( blockfloor number, blockcode number )
TABLE: CREATE TABLE physician ( employeeid number, name text, position text, ssn number )
TABLE: CREATE TABLE nurse ( employeeid number, name text, position text, registered boolean, ssn number )
TABLE: CREATE TABLE trained_in ( physician number, treatment number, certificationdate time, certificationexpires time )
TABLE: CREATE TABLE department ( departmentid number, name text, head number )
TABLE: CREATE TABLE prescribes ( physician number, patient number, medication number, date time, appointment number, dose text )
TABLE: CREATE TABLE patient ( ssn number, name text, address text, phone text, insuranceid number, pcp number )
TABLE: CREATE TABLE appointment ( appointmentid number, patient number, prepnurse number, physician number, start time, end time, examinationroom text )
TABLE: CREATE TABLE medication ( code number, name text, brand text, description text )

### Question ###
Find the name of medication used on the patient who stays in room 111?

### Accurate SQL ###

SELECT T4.name FROM stay AS T1 JOIN patient AS T2 ON T1.patient = T2.ssn JOIN prescribes AS T3 ON T3.patient = T2.ssn JOIN medication AS T4 ON T3.medication = T4.code WHERE room = 111