Question

I need a s sql code for three doctors information

dr James, musculo skeletal chiropractor, 15 years experience, D.C, Contact #

dr. Doe, wellness chiropractor, 10 years experience, D.C, Contact #

dr goose, symptom relief chiropractor, 11 years experience, D.C, Contact #

Answer 1

Please find below sql code and don't forget to give a Like.

Here, please replace the doctor_Table with original table name where this info is present.

replace doctor_name with Original column name of the doctor. name in the table.

Replace experience with Original column name for the experience in the table

Queries:

Select * from doctor_table where doctor_name like '%James%' and experience =15;

Select * from doctor_table where doctor_name like '%Doe%' and experience =10;

Select * from doctor_table where doctor_name like '%goose%' and experience =11;

If these data are present in multiple tables then please provide the tables with columns. So, that we can give the SQL queries for those relations.