Discover millions of ebooks, audiobooks, and so much more with a free trial

Only $11.99/month after trial. Cancel anytime.

The Making of a Doctor
The Making of a Doctor
The Making of a Doctor
Ebook1,366 pages16 hours

The Making of a Doctor

Rating: 0 out of 5 stars

()

Read preview

About this ebook

Part Two of C#.Net coding formulated by Segun using hundreds of pre-defined SQL queries to query (or question) the GP databases created by Segun, the physician, from his consultations and Python coding using potentially hundreds of MySQL queries to query the databases.
LanguageEnglish
Release dateDec 2, 2021
ISBN9781982284848
The Making of a Doctor

Read more from Julius Adebiyi Sodipo

Related to The Making of a Doctor

Related ebooks

Medical For You

View More

Related articles

Reviews for The Making of a Doctor

Rating: 0 out of 5 stars
0 ratings

0 ratings0 reviews

What did you think?

Tap to rate

Review must be at least 10 words

    Book preview

    The Making of a Doctor - Julius Adebiyi Sodipo

    VOLUME 15

    THE MAKING

    OF A DOCTOR

    JULIUS ADEBIYI SODIPO

    168963.png

    Copyright © 2022 Julius Adebiyi Sodipo.

    All rights reserved. No part of this book may be used or reproduced by any means,

    graphic, electronic, or mechanical, including photocopying, recording, taping or by

    any information storage retrieval system without the written permission of the author

    except in the case of brief quotations embodied in critical articles and reviews.

    Balboa Press

    A Division of Hay House

    1663 Liberty Drive

    Bloomington, IN 47403

    www.balboapress.co.uk

    UK TFN: 0800 0148647 (Toll Free inside the UK)

    UK Local: (02) 0369 56325 (+44 20 3695 6325 from outside the UK)

    Because of the dynamic nature of the Internet, any web addresses or links contained in

    this book may have changed since publication and may no longer be valid. The views

    expressed in this work are solely those of the author and do not necessarily reflect the

    views of the publisher, and the publisher hereby disclaims any responsibility for them.

    The author of this book does not dispense medical advice or prescribe the use of any

    technique as a form of treatment for physical, emotional, or medical problems without the

    advice of a physician, either directly or indirectly. The intent of the author is only to offer

    information of a general nature to help you in your quest for emotional and spiritual well-

    being. In the event you use any of the information in this book for yourself, which is your

    constitutional right, the author and the publisher assume no responsibility for your actions.

    Any people depicted in stock imagery provided by Getty Images are models,

    and such images are being used for illustrative purposes only.

    Certain stock imagery © Getty Images.

    ISBN: 978-1-9822-8483-1 (sc)

    ISBN: 978-1-9822-8485-5 (hc)

    ISBN: 978-1-9822-8484-8 (e)

    Balboa Press rev. date: 12/02/2021

    CONTENTS

    Dedication

    Appreciation

    Aim

    Introduction

    Experience of a solo GP (virtually) Practice in suburban England (C#.Net coding) Part 2

    Experience of a solo GP (virtually) Practice in suburban England (Python coding)

    DEDICATION

    I dedicate this book to my four sons:

    Julius Adedeji, John Adesola, Isaac Adetokunbo and Johnson Adeyinka;

    their mother Gloria Adanma;

    to the memory of my:

    father’s father Papa (Chief) Isaac Omolaja Sodipo;

    father’s mother Madam Bilewunmi-omo Sodipo (alias Iya Ita-oloti);

    mother’s mother Nee Alice Aina Ero-Phillips (alias Iya Alakara);

    mother Madam (Chief) Harriet Olufunke Ibidunni Sodipo

    father, Dr (Chief) John Adewunmi Akanbi Sodipo.

    APPRECIATION

    I will like to thank my wife, Gloria Adanma (Nee Okoroafor), for showing fleeting interests during the production of the whole project and to thank my son, Isaac Adetokunbo, for editing and proof-reading the book.

    AIM

    Any proceeds from the sale(s) or distribution of this book should be used in setting up a Fund, which should be invested in a safe investment. This fund should be called Dr Julius Adebiyi Sodipo’s Fund.

    All the proceeds being generated from the sale of the book (or project) as well as all the proceeds from his estate should be deposited as Capital into the fund. The managers of the Estate Fund should not get more than 10% of the income generated by the Fund each year. The proceeds in the Fund should be invested in a relatively safe investment and what is generated should be called the Fund Income.

    So, should any of the remaining of my estate, after deduction of any debts and taxes should be added to the Dr Julius Adebiyi Sodipo’s Fund. The monies in the fund should be distributed from time to time occasionally but regularly to my biological grandchildren, biological great grandchildren, biological great great grandchildren, and biological generations yet to be born with no conditions attached. For example, for those who are eligible i.e., my biological descendants, 30 percent of the yearly income should be distributed equally yearly rather than 5 percent monthly. Those who are managing the Fund and its distribution should receive 5 to 10 percent of the yearly income, as appropriate to use in maintaining the fund and as their fees.

    The remaining 90% (or 95%) of the yearly income generated by the Estate Fund, reiterated here, should be equally divided between the biological posterity of Dr Julius Adebiyi Sodipo for generations to come including those yet unborn for as long as possible as far as the Estate exists.

    The division of the Estate Fund’s income should be as follows: Each member of his (my) biological posterity should get their own share from the age of 30 years old until the age of 55 years old, or they are no longer alive if this should happen earlier. As reiterated earlier their own share should be given to them yearly or more frequently if the managers feel it is in the best interest of the recipient to do so.

    An independent legal firm (team) mutually agreeable to most of the stakeholders must be employed. The legal firm is to ensure the smooth running by the Fund Managers, to ensure that the managers keep to the protocol set out above or not to significantly deviate from it. The legal team should receive 5% of the yearly income of the fund as their renumeration.

    INTRODUCTION

    This idea and realism of writing this book came to me to write a brief overview of Segun as a teenager in his country of birth of Nigeria and to travel through his journey from then until about his retirement as a doctor. There will be inevitable gaps, for which Segun whole-heartedly apologises. A sizeable amount is allocated to life before his university days. There is a noticeable abrupt end and allocation of the book towards his experience as a medical student. This is done on purpose in view of the way Segun felt and still feels being unfairly treated towards the end of his period as a student in the University.

    Efforts to introduce his experiences as a doctor are deliberate and apologies for any perceived idea of turning the contents of the book to more of science. Segun feels this is necessary to be able to show his experiences and knowledge as a medical doctor.

    173819.png

    EXPERIENCE OF A SOLO GP

    (VIRTUALLY) PRACTICE

    IN SUBURBAN ENGLAND

    (C#.NET CODING) PART 2

    //sqlQuestion[0] = Write a query that lists all patients seen in March 1997 whose notes entries began with the letter ‘C’;

    //sqlQuestion[1] = Write a query that displays all the consultations in March 1997 and March 1998;

    //sqlQuestion[2] = Write a query that lists all patients seen in March 1997 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 1997 and have similar diagnosis in March 1998;

    //sqlQuestion[3] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 1997;

    //sqlQuestion[4] = Write a query that lists those seen in March 1997 who have similar complaints as those seen in March 1998;

    //sqlQuestion[5] = Write a query to list all those referred in March 1997;

    //sqlQuestion[6] = Write a query that lists all consultations in the first week of March 1997;

    //sqlQuestion[7] = Write a query that lists all consultations in the second week of March 1997;

    //sqlQuestion[8] = Write a query that lists all consultations in the third week of March 1997;

    //sqlQuestion[9] = Write a query that lists all consultations from the 22nd to the end of March 1997;

    //sqlQuestion[10] = Write a query that lists all consultations seen in March 1997 who had similarly entered complaints and similarly entered treatments in both months March 1997 and March 1998, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[11] = Write a query that lists all the consultations seen in March 1997 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 1998;

    //sqlQuestion[12] = Write a query that lists all patients seen in March 1997 who have similar diagnosis as those seen in March 1998;

    //sqlQuestion[13] = Write a query that lists all consultations in March 1997 who have similar entries under treatments as the consultations seen in March 1998. Both years consultations must have entries under Notes;

    //sqlQuestion[14] = Write a query that lists those seen in March 1997 who have similar complaints as those seen in March 1998;

    //sqlQuestion[15] = Write a query that lists all consultations seen in March 1997 who had similarly complaints entries as those seen in March 1998, both having consultation time of more than 10 minutes;

    //sqlQuestion[16] = Write a query that lists all consultations seen in March 1997 who had similarly entered diagnosis as those seen in March 1998;

    //sqlQuestion[17] = Write a query that lists all those seen in March 1997 and March 1998;

    //sqlQuestion[18] = Write a query that lists all consultations seen in March 1997 who had entries of URTI under Diagnosis And patients seen in March 1998 who also had similar entries under Diagnosis;

    //sqlQuestion[19] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 1997;

    //sqlQuestion[20] = Write a query that selects the last fifty seen appointments in March 1997;

    //sqlQuestion[21] = Write a query that lists the 20 earliest appointments in March 1997;

    //sqlQuestion[22] = Write a query that lists all patients seen in March 1998 whose notes entries began with the letter ‘C’;

    //sqlQuestion[23] = Write a query that displays all the consultations in March 1998 and March 1999;

    //sqlQuestion[24] = Write a query that lists all patients seen in March 1998 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 1998 and have similar diagnosis in March 1999;

    //sqlQuestion[25] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 1998;

    //sqlQuestion[26] = Write a query that lists those seen in March 1998 who have similar complaints as those seen in March 1999;

    //sqlQuestion[27] = Write a query to list all those referred in March 1998;

    //sqlQuestion[28] = Write a query that lists all consultations in the first week of March 1998;

    //sqlQuestion[29] = Write a query that lists all consultations in the second week of March 1998;

    //sqlQuestion[30] = Write a query that lists all consultations in the third week of March 1998;

    //sqlQuestion[31] = Write a query that lists all consultations from the 22nd to the end of March 1998;

    //sqlQuestion[32] = Write a query that lists all consultations seen in March 1998 who had similarly entered complaints and similarly entered treatments in both months March 1998 and March 1999, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[33] = Write a query that lists all the consultations seen in March 1998 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 1999;

    //sqlQuestion[34] = Write a query that lists all patients seen in March 1998 who have similar diagnosis as those seen in March 1999;

    //sqlQuestion[35] = Write a query that lists all consultations in March 1998 who have similar entries under treatments as the consultations seen in March 1999. Both years consultations must have entries under Notes;

    //sqlQuestion[36] = Write a query that lists those seen in March 1998 who have similar complaints as those seen in March 1999;

    //sqlQuestion[37] = Write a query that lists all consultations seen in March 1998 who had similarly complaints entries as those seen in March 1999, both having consultation time of more than 10 minutes;

    //sqlQuestion[38] = Write a query that lists all consultations seen in March 1998 who had similarly entered diagnosis as those seen in March 1999;

    //sqlQuestion[39] = Write a query that lists all those seen in March 1998 and March 1999;

    //sqlQuestion[40] = Write a query that lists all consultations seen in March 1998 who had entries of URTI under Diagnosis And patients seen in March 1999 who also had similar entries under Diagnosis;

    //sqlQuestion[41] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 1998;

    //sqlQuestion[42] = Write a query that selects the last fifty seen appointments in March 1998;

    //sqlQuestion[43] = Write a query that lists the 20 earliest appointments in March 1998;

    //sqlQuestion[44] = Write a query that lists all patients seen in March 1999 whose notes entries began with the letter ‘C’;

    //sqlQuestion[45] = Write a query that displays all the consultations in March 1999 and March 2000;

    //sqlQuestion[46] = Write a query that lists all patients seen in March 1999 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 1997 and have similar diagnosis in March 1998;

    //sqlQuestion[47] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 1999;

    //sqlQuestion[48] = Write a query that lists those seen in March 1999 who have similar complaints as those seen in March 1998;

    //sqlQuestion[49] = Write a query to list all those referred in March 1999;

    //sqlQuestion[50] = Write a query that lists all consultations in the first week of March 1999;

    //sqlQuestion[51] = Write a query that lists all consultations in the second week of March 1999;

    //sqlQuestion[52] = Write a query that lists all consultations in the third week of March 1999;

    //sqlQuestion[53] = Write a query that lists all consultations from the 22nd to the end of March 1999;

    //sqlQuestion[54] = Write a query that lists all consultations seen in March 1999 who had similarly entered complaints and similarly entered treatments in both months March 1999 and March 2000, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[55] = Write a query that lists all the consultations seen in March 1999 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 1998;

    //sqlQuestion[56] = Write a query that lists all patients seen in March 1999 who have similar diagnosis as those seen in March 1998;

    //sqlQuestion[57] = Write a query that lists all consultations in March 1999 who have similar entries under treatments as the consultations seen in March 1998. Both years consultations must have entries under Notes;

    //sqlQuestion[58] = Write a query that lists those seen in March 1999 who have similar complaints as those seen in March 1998;

    //sqlQuestion[59] = Write a query that lists all consultations seen in March 1999 who had similarly complaints entries as those seen in March 1998, both having consultation time of more than 10 minutes;

    //sqlQuestion[60] = Write a query that lists all consultations seen in March 1999 who had similarly entered diagnosis as those seen in March 1998;

    //sqlQuestion[61] = Write a query that lists all those seen in March 1999 and March 1998;

    //sqlQuestion[62] = Write a query that lists all consultations seen in March 1999 who had entries of URTI under Diagnosis And patients seen in March 1998 who also had similar entries under Diagnosis;

    //sqlQuestion[63] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 1999;

    //sqlQuestion[64] = Write a query that selects the last fifty seen appointments in March 1999;

    //sqlQuestion[65] = Write a query that lists the 20 earliest appointments in March 1999;

    //sqlQuestion[66] = Write a query that lists all patients seen in March 2000 whose notes entries began with the letter ‘C’;

    //sqlQuestion[67] = Write a query that displays all the consultations in March 2000 and March 2001;

    //sqlQuestion[68] = Write a query that lists all patients seen in March 2000 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2000 and have similar diagnosis in March 2001;

    //sqlQuestion[69] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2000;

    //sqlQuestion[70] = Write a query that lists those seen in March 2000 who have similar complaints as those seen in March 2001;

    //sqlQuestion[71] = Write a query to list all those referred in March 2000;

    //sqlQuestion[72] = Write a query that lists all consultations in the first week of March 2000;

    //sqlQuestion[73] = Write a query that lists all consultations in the second week of March 2000;

    //sqlQuestion[74] = Write a query that lists all consultations in the third week of March 2000;

    //sqlQuestion[75] = Write a query that lists all consultations from the 22nd to the end of March 2000;

    //sqlQuestion[76] = Write a query that lists all consultations seen in March 2000 who had similarly entered complaints and similarly entered treatments in both months March 2000 and March 2001, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[77] = Write a query that lists all the consultations seen in March 2000 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2001;

    //sqlQuestion[78] = Write a query that lists all patients seen in March 2000 who have similar diagnosis as those seen in March 2001;

    //sqlQuestion[79] = Write a query that lists all consultations in March 2000 who have similar entries under treatments as the consultations seen in March 2001. Both years consultations must have entries under Notes;

    //sqlQuestion[80] = Write a query that lists those seen in March 2000 who have similar complaints as those seen in March 2001;

    //sqlQuestion[81] = Write a query that lists all consultations seen in March 2000 who had similarly complaints entries as those seen in March 2001, both having consultation time of more than 10 minutes;

    //sqlQuestion[82] = Write a query that lists all consultations seen in March 2000 who had similarly entered diagnosis as those seen in March 2001;

    //sqlQuestion[83] = Write a query that lists all those seen in March 2000 and March 2001;

    //sqlQuestion[84] = Write a query that lists all consultations seen in March 2000 who had entries of URTI under Diagnosis And patients seen in March 2001 who also had similar entries under Diagnosis;

    //sqlQuestion[85] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2000;

    //sqlQuestion[86] = Write a query that selects the last fifty seen appointments in March 2000;

    //sqlQuestion[87] = Write a query that lists the 20 earliest appointments in March 2000;

    //sqlQuestion[88] = Write a query that lists all patients seen in March 2001 whose notes entries began with the letter ‘C’;

    //sqlQuestion[89] = Write a query that displays all the consultations in March 2001 and March 2002;

    //sqlQuestion[90] = Write a query that lists all patients seen in March 2001 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2001 and have similar diagnosis in March 2002;

    //sqlQuestion[91] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2001;

    //sqlQuestion[92] = Write a query that lists those seen in March 2001 who have similar complaints as those seen in March 2002;

    //sqlQuestion[93] = Write a query to list all those referred in March 2001;

    //sqlQuestion[94] = Write a query that lists all consultations in the first week of March 2001;

    //sqlQuestion[95] = Write a query that lists all consultations in the second week of March 2001;

    //sqlQuestion[96] = Write a query that lists all consultations in the third week of March 2001;

    //sqlQuestion[97] = Write a query that lists all consultations from the 22nd to the end of March 2001;

    //sqlQuestion[98] = Write a query that lists all consultations seen in March 2001 who had similarly entered complaints and similarly entered treatments in both months March 2001 and March 2002, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[99] = Write a query that lists all the consultations seen in March 2001 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2002;

    //sqlQuestion[100] = Write a query that lists all patients seen in March 2001 who have similar diagnosis as those seen in March 2002;

    //sqlQuestion[101] = Write a query that lists all consultations in March 2001 who have similar entries under treatments as the consultations seen in March 2002. Both years consultations must have entries under Notes;

    //sqlQuestion[102] = Write a query that lists those seen in March 2001 who have similar complaints as those seen in March 2002;

    //sqlQuestion[103] = Write a query that lists all consultations seen in March 2001 who had similarly complaints entries as those seen in March 2002, both having consultation time of more than 10 minutes;

    //sqlQuestion[104] = Write a query that lists all consultations seen in March 2001 who had similarly entered diagnosis as those seen in March 2002;

    //sqlQuestion[105] = Write a query that lists all those seen in March 2001 and March 2002;

    //sqlQuestion[106] = Write a query that lists all consultations seen in March 2001 who had entries of URTI under Diagnosis And patients seen in March 2002 who also had similar entries under Diagnosis;

    //sqlQuestion[107] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2001;

    //sqlQuestion[108] = Write a query that selects the last fifty seen appointments in March 2001;

    //sqlQuestion[109] = Write a query that lists the 20 earliest appointments in March 2001;

    //sqlQuestion[110] = Write a query that lists all patients seen in March 2002 whose notes entries began with the letter ‘C’;

    //sqlQuestion[111] = Write a query that displays all the consultations in March 2002 and March 2003;

    //sqlQuestion[112] = Write a query that lists all patients seen in March 2002 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2002 and have similar diagnosis in March 2003;

    //sqlQuestion[113] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2002;

    //sqlQuestion[114] = Write a query that lists those seen in March 2002 who have similar complaints as those seen in March 2003;

    //sqlQuestion[115] = Write a query to list all those referred in March 2002;

    //sqlQuestion[116] = Write a query that lists all consultations in the first week of March 2002;

    //sqlQuestion[117] = Write a query that lists all consultations in the second week of March 2002;

    //sqlQuestion[118] = Write a query that lists all consultations in the third week of March 2002;

    //sqlQuestion[119] = Write a query that lists all consultations from the 22nd to the end of March 2002;

    //sqlQuestion[120] = Write a query that lists all consultations seen in March 2002 who had similarly entered complaints and similarly entered treatments in both months March 2002 and March 2003, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[121] = Write a query that lists all the consultations seen in March 2002 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2003;

    //sqlQuestion[122] = Write a query that lists all patients seen in March 2002 who have similar diagnosis as those seen in March 2003;

    //sqlQuestion[123] = Write a query that lists all consultations in March 2002 who have similar entries under treatments as the consultations seen in March 2003. Both years consultations must have entries under Notes;

    //sqlQuestion[124] = Write a query that lists those seen in March 2002 who have similar complaints as those seen in March 2003;

    //sqlQuestion[125] = Write a query that lists all consultations seen in March 2002 who had similarly complaints entries as those seen in March 2003, both having consultation time of more than 10 minutes;

    //sqlQuestion[126] = Write a query that lists all consultations seen in March 2002 who had similarly entered diagnosis as those seen in March 2003;

    //sqlQuestion[127] = Write a query that lists all those seen in March 2002 and March 2003;

    //sqlQuestion[128] = Write a query that lists all consultations seen in March 2002 who had entries of URTI under Diagnosis And patients seen in March 2003 who also had similar entries under Diagnosis;

    //sqlQuestion[129] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2002;

    //sqlQuestion[130] = Write a query that selects the last fifty seen appointments in March 2002;

    //sqlQuestion[131] = Write a query that lists the 20 earliest appointments in March 2002;

    //sqlQuestion[132] = Write a query that lists all patients seen in March 2003 whose notes entries began with the letter ‘C’;

    //sqlQuestion[133] = Write a query that displays all the consultations in March 2003 and March 2004;

    //sqlQuestion[134] = Write a query that lists all patients seen in March 2003 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2003 and have similar diagnosis in March 2004;

    //sqlQuestion[135] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2003;

    //sqlQuestion[136] = Write a query that lists those seen in March 2003 who have similar complaints as those seen in March 2004;

    //sqlQuestion[137] = Write a query to list all those referred in March 2003;

    //sqlQuestion[138] = Write a query that lists all consultations in the first week of March 2003;

    //sqlQuestion[139] = Write a query that lists all consultations in the second week of March 2003;

    //sqlQuestion[140] = Write a query that lists all consultations in the third week of March 2003;

    //sqlQuestion[141] = Write a query that lists all consultations from the 22nd to the end of March 2003;

    //sqlQuestion[142] = Write a query that lists all consultations seen in March 2003 who had similarly entered complaints and similarly entered treatments in both months March 2003 and March 2004, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[143] = Write a query that lists all the consultations seen in March 2003 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2004;

    //sqlQuestion[144] = Write a query that lists all patients seen in March 2003 who have similar diagnosis as those seen in March 2004;

    //sqlQuestion[145] = Write a query that lists all consultations in March 2003 who have similar entries under treatments as the consultations seen in March 2004. Both years consultations must have entries under Notes;

    //sqlQuestion[146] = Write a query that lists those seen in March 2003 who have similar complaints as those seen in March 2004;

    //sqlQuestion[147] = Write a query that lists all consultations seen in March 2003 who had similarly complaints entries as those seen in March 2004, both having consultation time of more than 10 minutes;

    //sqlQuestion[148] = Write a query that lists all consultations seen in March 2003 who had similarly entered diagnosis as those seen in March 2004;

    //sqlQuestion[149] = Write a query that lists all those seen in March 2003 and March 2004;

    //sqlQuestion[150] = Write a query that lists all consultations seen in March 2003 who had entries of URTI under Diagnosis And patients seen in March 2004 who also had similar entries under Diagnosis;

    //sqlQuestion[151] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2003;

    //sqlQuestion[152] = Write a query that selects the last fifty seen appointments in March 2003;

    //sqlQuestion[153] = Write a query that lists the 20 earliest appointments in March 2003;

    //sqlQuestion[154] = Write a query that lists all patients seen in March 2004 whose notes entries began with the letter ‘C’;

    //sqlQuestion[155] = Write a query that displays all the consultations in March 2004 and March 2005;

    //sqlQuestion[156] = Write a query that lists all patients seen in March 2004 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2004 and have similar diagnosis in March 2005;

    //sqlQuestion[157] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2004;

    //sqlQuestion[158] = Write a query that lists those seen in March 2004 who have similar complaints as those seen in March 2005;

    //sqlQuestion[159] = Write a query to list all those referred in March 2004;

    //sqlQuestion[160] = Write a query that lists all consultations in the first week of March 2004;

    //sqlQuestion[161] = Write a query that lists all consultations in the second week of March 2004;

    //sqlQuestion[162] = Write a query that lists all consultations in the third week of March 2004;

    //sqlQuestion[163] = Write a query that lists all consultations from the 22nd to the end of March 2004;

    //sqlQuestion[164] = Write a query that lists all consultations seen in March 2004 who had similarly entered complaints and similarly entered treatments in both months March 2004 and March 2005, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[165] = Write a query that lists all the consultations seen in March 2004 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2005;

    //sqlQuestion[166] = Write a query that lists all patients seen in March 2004 who have similar diagnosis as those seen in March 2005;

    //sqlQuestion[167] = Write a query that lists all consultations in March 2004 who have similar entries under treatments as the consultations seen in March 2005. Both years consultations must have entries under Notes;

    //sqlQuestion[168] = Write a query that lists those seen in March 2004 who have similar complaints as those seen in March 2005;

    //sqlQuestion[169] = Write a query that lists all consultations seen in March 2004 who had similarly complaints entries as those seen in March 2005, both having consultation time of more than 10 minutes;

    //sqlQuestion[170] = Write a query that lists all consultations seen in March 2004 who had similarly entered diagnosis as those seen in March 2005;

    //sqlQuestion[171] = Write a query that lists all those seen in March 2004 and March 2005;

    //sqlQuestion[172] = Write a query that lists all consultations seen in March 2004 who had entries of URTI under Diagnosis And patients seen in March 2005 who also had similar entries under Diagnosis;

    //sqlQuestion[173] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2004;

    //sqlQuestion[174] = Write a query that selects the last fifty seen appointments in March 2004;

    //sqlQuestion[175] = Write a query that lists the 20 earliest appointments in March 2004;

    //sqlQuestion[176] = Write a query that lists all patients seen in March 2005 whose notes entries began with the letter ‘C’;

    //sqlQuestion[177] = Write a query that displays all the consultations in March 2005 and March 1997;

    //sqlQuestion[178] = Write a query that lists all patients seen in March 2005 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2005 and have similar diagnosis in March 1997;

    //sqlQuestion[179] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2005;

    //sqlQuestion[180] = Write a query that lists those seen in March 2005 who have similar complaints as those seen in March 1997;

    //sqlQuestion[181] = Write a query to list all those referred in March 2005;

    //sqlQuestion[182] = Write a query that lists all consultations in the first week of March 2005;

    //sqlQuestion[183] = Write a query that lists all consultations in the second week of March 2005;

    //sqlQuestion[184] = Write a query that lists all consultations in the third week of March 2005;

    //sqlQuestion[185] = Write a query that lists all consultations from the 22nd to the end of March 2005;

    //sqlQuestion[186] = Write a query that lists all consultations seen in March 2005 who had similarly entered complaints and similarly entered treatments in both months March 2005 and March 1997, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months;

    //sqlQuestion[187] = Write a query that lists all the consultations seen in March 2005 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 1997;

    //sqlQuestion[188] = Write a query that lists all patients seen in March 2005 who have similar diagnosis as those seen in March 1997;

    //sqlQuestion[189] = Write a query that lists all consultations in March 2005 who have similar entries under treatments as the consultations seen in March 1997. Both years consultations must have entries under Notes;

    //sqlQuestion[190] = Write a query that lists those seen in March 2005 who have similar complaints as those seen in March 1997;

    //sqlQuestion[191] = Write a query that lists all consultations seen in March 2005 who had similarly complaints entries as those seen in March 1997, both having consultation time of more than 10 minutes;

    //sqlQuestion[192] = Write a query that lists all consultations seen in March 2005 who had similarly entered diagnosis as those seen in March 1997;

    //sqlQuestion[193] = Write a query that lists all those seen in March 2005 and March 1997;

    //sqlQuestion[194] = Write a query that lists all consultations seen in March 2005 who had entries of URTI under Diagnosis And patients seen in March 1997 who also had similar entries under Diagnosis;

    //sqlQuestion[195] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2005;

    //sqlQuestion[196] = Write a query that selects the last fifty seen appointments in March 2005;

    //sqlQuestion[197] = Write a query that lists the 20 earliest appointments in March 2005;

    //sqlQuestion[198] = Write a query that lists all patients seen in March 2006 whose notes entries contain the letter ‘C’ ;

    //sqlQuestion[199] = Write a query that displays all the consultations in March 2006 and March 2007 ;

    //sqlQuestion[200] = Write a query that lists all patients seen in March 2006 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2006 and have similar diagnosis in March 2007 ;

    //sqlQuestion[201] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2006 ;

    //sqlQuestion[202] = Write a query that lists those seen in March 2006 who have similar complaints as those seen in March 2007 ;

    //sqlQuestion[203] = Write a query to list all those referred in March 2006 ;

    //sqlQuestion[204] = Write a query that lists all consultations in the first week of March 2006 ;

    //sqlQuestion[205] = Write a query that lists all consultations in the second week of March 2006 ;

    //sqlQuestion[206] = Write a query that lists all consultations in the third week of March 2006 ;

    //sqlQuestion[207] = Write a query that lists all consultations from the 22nd to the end of March 2006 ;

    //sqlQuestion[208] = Write a query that lists all the consultations in March 2006 who had similar entries under treatments As the consultations seen In March 2007. Both years consultations must have entries under Notes ;

    //sqlQuestion[209] = Write a query that lists all the consultations seen in March 2006 who had similarly entered notes, similarly entered treatments Or similarly entered date of births in March 2007 ;

    //sqlQuestion[210] = Write a query that lists all patients seen in March 2006 who have similar diagnosis as those seen in March 2007 ;

    //sqlQuestion[211] = Write a query that lists all consultations in March 2006 who have similar entries under treatments as the consultations seen in March 2007. Both years consultations must have entries under Notes ;

    //sqlQuestion[212] = Write a query that lists those seen in March 2006 who have similar complaints as those seen in March 2007 ;

    //sqlQuestion[213] = Write a query that lists all consultations seen in March 2006 who had similarly complaints entries as those seen in March 2007, both having consultation time of more than 10 minutes ;

    //sqlQuestion[214] = Write a query that lists all consultations seen in March 2006 who had similarly entered diagnosis as those seen in March 2007 ;

    //sqlQuestion[215] = Write a query that lists all those seen in March 2006 and March 2007 ;

    //sqlQuestion[216] = Write a query that lists all consultations seen in March 2006 who had entries of URTI under Diagnosis And patients seen in March 2007 who also had similar entries under Diagnosis ;

    //sqlQuestion[217] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2006 ;

    //sqlQuestion[218] = Write a query that selects the last fifty seen appointments in March 2006 ;

    //sqlQuestion[219] = Write a query that lists the 20 earliest appointments in March 2006

    //sqlQuestion[220] = Write a query that lists all patients seen in March 2007 whose notes entries contain the letter ‘C’ ;

    //sqlQuestion[221] = Write a query that displays all the consultations in March 2007 and March 2008 ;

    //sqlQuestion[222] = Write a query that lists all patients seen in March 2007 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2007 and have similar diagnosis in March 2008 ;

    //sqlQuestion[223] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2007 ;

    //sqlQuestion[224] = Write a query that lists those seen in March 2007 who have similar complaints as those seen in March 2008 ;

    //sqlQuestion[225] = Write a query to list all those referred in March 2007 ;

    //sqlQuestion[226] = Write a query that lists all consultations in the first week of March 2007 ;

    //sqlQuestion[227] = Write a query that lists all consultations in the second week of March 2007 ;

    //sqlQuestion[228] = Write a query that lists all consultations in the third week of March 2007 ;

    //sqlQuestion[229] = Write a query that lists all consultations from the 22nd to the end of March 2007 ;

    //sqlQuestion[230] = Write a query that lists all consultations seen in March 2007 who had similarly entered complaints and similarly entered treatments in both months March 2007 and March 2008, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months ;

    //sqlQuestion[231] = Write a query that lists all the consultations seen in March 2007 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2008 ;

    //sqlQuestion[232] = Write a query that lists all patients seen in March 2007 who have similar diagnosis as those seen in March 2008 ;

    //sqlQuestion[233] = Write a query that lists all consultations in March 2007 who have similar entries under treatments as the consultations seen in March 2008. Both years consultations must have entries under Notes ;

    //sqlQuestion[234] = Write a query that lists those seen in March 2007 who have similar complaints as those seen in March 2008 ;

    //sqlQuestion[235] = Write a query that lists all consultations seen in March 2007 who had similarly complaints entries as those seen in March 2008, both having consultation time of more than 10 minutes ;

    //sqlQuestion[236] = Write a query that lists all consultations seen in March 2007 who had similarly entered diagnosis as those seen in March 2008 ;

    //sqlQuestion[237] = Write a query that lists all those seen in March 2007 and March 2008 ;

    //sqlQuestion[238] = Write a query that lists all consultations seen in March 2007 who had entries of URTI under Diagnosis And patients seen in March 2008 who also had similar entries under Diagnosis ;

    //sqlQuestion[239] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2007 ;

    //sqlQuestion[240] = Write a query that selects the last fifty seen appointments in March 2007 ;

    //sqlQuestion[241] = Write a query that lists the 20 earliest appointments in March 2007 ;

    //sqlQuestion[242] = Write a query that lists all patients seen in March 2008 whose notes entries contain the letter ‘C’ ;

    //sqlQuestion[243] = Write a query that displays all the consultations in March 2008 and March 2009 ;

    //sqlQuestion[244] = Write a query that lists all patients seen in March 2008 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 1997 and have similar diagnosis in March 1998 ;

    //sqlQuestion[245] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2008 ;

    //sqlQuestion[246] = Write a query that lists those seen in March 2008 who have similar complaints as those seen in March 1998 ;

    //sqlQuestion[247] = Write a query to list all those referred in March 2008 ;

    //sqlQuestion[248] = Write a query that lists all consultations in the first week of March 2008 ;

    //sqlQuestion[249] = Write a query that lists all consultations in the second week of March 2008 ;

    //sqlQuestion[250] = Write a query that lists all consultations in the third week of March 2008 ;

    //sqlQuestion[251] = Write a query that lists all consultations from the 22nd to the end of March 2008 ;

    //sqlQuestion[252] = Write a query that lists all consultations seen in March 2008 who had similarly entered complaints and similarly entered treatments in both months March 2008 and March 2009, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months ;

    //sqlQuestion[253] = Write a query that lists all the consultations seen in March 2008 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 1998 ;

    //sqlQuestion[254] = Write a query that lists all patients seen in March 2008 who have similar diagnosis as those seen in March 1998 ;

    //sqlQuestion[255] = Write a query that lists all consultations in March 2008 who have similar entries under treatments as the consultations seen in March 1998. Both years consultations must have entries under Notes ;

    //sqlQuestion[256] = Write a query that lists those seen in March 2008 who have similar complaints as those seen in March 1998 ;

    //sqlQuestion[257] = Write a query that lists all consultations seen in March 2008 who had similarly complaints entries as those seen in March 1998, both having consultation time of more than 10 minutes ;

    //sqlQuestion[258] = Write a query that lists all consultations seen in March 2008 who had similarly entered diagnosis as those seen in March 1998 ;

    //sqlQuestion[259] = Write a query that lists all those seen in March 2008 and March 1998 ;

    //sqlQuestion[260] = Write a query that lists all consultations seen in March 2008 who had entries of URTI under Diagnosis And patients seen in March 1998 who also had similar entries under Diagnosis ;

    //sqlQuestion[261] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2008 ;

    //sqlQuestion[262] = Write a query that selects the last fifty seen appointments in March 2008 ;

    //sqlQuestion[263] = Write a query that lists the 20 earliest appointments in March 2008 ;

    //sqlQuestion[264] = Write a query that lists all patients seen in March 2009 whose notes entries contain the letter ‘C’ ;

    //sqlQuestion[265] = Write a query that displays all the consultations in March 2009 and March 2010 ;

    //sqlQuestion[266] = Write a query that lists all patients seen in March 2009 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2009 and have similar diagnosis in March 2010 ;

    //sqlQuestion[267] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2009 ;

    //sqlQuestion[268] = Write a query that lists those seen in March 2009 who have similar complaints as those seen in March 2010 ;

    //sqlQuestion[269] = Write a query to list all those referred in March 2009 ;

    //sqlQuestion[270] = Write a query that lists all consultations in the first week of March 2009 ;

    //sqlQuestion[271] = Write a query that lists all consultations in the second week of March 2009 ;

    //sqlQuestion[272] = Write a query that lists all consultations in the third week of March 2009 ;

    //sqlQuestion[273] = Write a query that lists all consultations from the 22nd to the end of March 2009 ;

    //sqlQuestion[274] = Write a query that lists all consultations seen in March 2009 who had similarly entered complaints and similarly entered treatments in both months March 2009 and March 2010, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months ;

    //sqlQuestion[275] = Write a query that lists all the consultations seen in March 2009 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2010 ;

    //sqlQuestion[276] = Write a query that lists all patients seen in March 2009 who have similar diagnosis as those seen in March 2010 ;

    //sqlQuestion[277] = Write a query that lists all consultations in March 2009 who have similar entries under treatments as the consultations seen in March 2010. Both years consultations must have entries under Notes ;

    //sqlQuestion[278] = Write a query that lists those seen in March 2009 who have similar complaints as those seen in March 2010 ;

    //sqlQuestion[279] = Write a query that lists all consultations seen in March 2009 who had similarly complaints entries as those seen in March 2010, both having consultation time of more than 10 minutes ;

    //sqlQuestion[280] = Write a query that lists all consultations seen in March 2009 who had similarly entered diagnosis as those seen in March 2010 ;

    //sqlQuestion[281] = Write a query that lists all those seen in March 2009 and March 2010 ;

    //sqlQuestion[282] = Write a query that lists all consultations seen in March 2009 who had entries of URTI under Diagnosis And patients seen in March 2010 who also had similar entries under Diagnosis ;

    //sqlQuestion[283] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2009 ;

    //sqlQuestion[284] = Write a query that selects the last fifty seen appointments in March 2009 ;

    //sqlQuestion[285] = Write a query that lists the 20 earliest appointments in March 2009 ;

    //sqlQuestion[286] = Write a query that lists all patients seen in March 2010 whose notes entries contain the letter ‘C’ ;

    //sqlQuestion[287] = Write a query that displays all the consultations in March 2010 and March 2011 ;

    //sqlQuestion[288] = Write a query that lists all patients seen in March 2010 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2010 and have similar diagnosis in March 2011 ;

    //sqlQuestion[289] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2010 ;

    //sqlQuestion[290] = Write a query that lists those seen in March 2010 who have similar complaints as those seen in March 2011 ;

    //sqlQuestion[291] = Write a query to list all those referred in March 2010 ;

    //sqlQuestion[292] = Write a query that lists all consultations in the first week of March 2010 ;

    //sqlQuestion[293] = Write a query that lists all consultations in the second week of March 2010 ;

    //sqlQuestion[294] = Write a query that lists all consultations in the third week of March 2010 ;

    //sqlQuestion[295] = Write a query that lists all consultations from the 22nd to the end of March 2010 ;

    //sqlQuestion[296] = Write a query that lists all consultations seen in March 2010 who had similarly entered complaints and similarly entered treatments in both months March 2010 and March 2011, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months ;

    //sqlQuestion[297] = Write a query that lists all the consultations seen in March 2010 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2011 ;

    //sqlQuestion[298] = Write a query that lists all patients seen in March 2010 who have similar diagnosis as those seen in March 2011 ;

    //sqlQuestion[299] = Write a query that lists all consultations in March 2010 who have similar entries under treatments as the consultations seen in March 2011. Both years consultations must have entries under Notes ;

    //sqlQuestion[300] = Write a query that lists those seen in March 2010 who have similar complaints as those seen in March 2011 ;

    //sqlQuestion[301] = Write a query that lists all consultations seen in March 2010 who had similarly complaints entries as those seen in March 2011, both having consultation time of more than 10 minutes ;

    //sqlQuestion[302] = Write a query that lists all consultations seen in March 2010 who had similarly entered diagnosis as those seen in March 2011 ;

    //sqlQuestion[303] = Write a query that lists all those seen in March 2010 and March 2011 ;

    //sqlQuestion[304] = Write a query that lists all consultations seen in March 2010 who had entries of URTI under Diagnosis And patients seen in March 2011 who also had similar entries under Diagnosis ;

    //sqlQuestion[305] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2010 ;

    //sqlQuestion[306] = Write a query that selects the last fifty seen appointments in March 2010 ;

    //sqlQuestion[307] = Write a query that lists the 20 earliest appointments in March 2010 ;

    //sqlQuestion[308] = Write a query that lists all patients seen in March 2011 whose notes entries contain the letter ‘C’ ;

    //sqlQuestion[309] = Write a query that displays all the consultations in March 2011 and March 2012 ;

    //sqlQuestion[310] = Write a query that lists all patients seen in March 2011 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2011 and have similar diagnosis in March 2012 ;

    //sqlQuestion[311] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2011 ;

    //sqlQuestion[312] = Write a query that lists those seen in March 2011 who have similar complaints as those seen in March 2012 ;

    //sqlQuestion[313] = Write a query to list all those referred in March 2011 ;

    //sqlQuestion[314] = Write a query that lists all consultations in the first week of March 2011 ;

    //sqlQuestion[315] = Write a query that lists all consultations in the second week of March 2011 ;

    //sqlQuestion[316] = Write a query that lists all consultations in the third week of March 2011 ;

    //sqlQuestion[317] = Write a query that lists all consultations from the 22nd to the end of March 2011 ;

    //sqlQuestion[318] = Write a query that lists all consultations seen in March 2011 who had similarly entered complaints and similarly entered treatments in both months March 2011 and March 2012, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months ;

    //sqlQuestion[319] = Write a query that lists all the consultations seen in March 2011 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2012 ;

    //sqlQuestion[320] = Write a query that lists all patients seen in March 2011 who have similar diagnosis as those seen in March 2012 ;

    //sqlQuestion[321] = Write a query that lists all consultations in March 2011 who have similar entries under treatments as the consultations seen in March 2012. Both years consultations must have entries under Notes ;

    //sqlQuestion[322] = Write a query that lists those seen in March 2011 who have similar complaints as those seen in March 2012 ;

    //sqlQuestion[323] = Write a query that lists all consultations seen in March 2011 who had similarly complaints entries as those seen in March 2012, both having consultation time of more than 10 minutes ;

    //sqlQuestion[324] = Write a query that lists all consultations seen in March 2011 who had similarly entered diagnosis as those seen in March 2012 ;

    //sqlQuestion[325] = Write a query that lists all those seen in March 2011 and March 2012 ;

    //sqlQuestion[326] = Write a query that lists all consultations seen in March 2011 who had entries of URTI under Diagnosis And patients seen in March 2012 who also had similar entries under Diagnosis ;

    //sqlQuestion[327] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2011 ;

    //sqlQuestion[328] = Write a query that selects the last fifty seen appointments in March 2011 ;

    //sqlQuestion[329] = Write a query that lists the 20 earliest appointments in March 2011 ;

    //sqlQuestion[330] = Write a query that lists all patients seen in March 2012 whose notes entries contain the letter ‘C’ ;

    //sqlQuestion[331] = Write a query that displays all the consultations in March 2012 and March 2013 ;

    //sqlQuestion[332] = Write a query that lists all patients seen in March 2012 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2012 and have similar diagnosis in March 2013 ;

    //sqlQuestion[333] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2012 ;

    //sqlQuestion[334] = Write a query that lists those seen in March 2012 who have similar complaints as those seen in March 2013 ;

    //sqlQuestion[335] = Write a query to list all those referred in March 2012 ;

    //sqlQuestion[336] = Write a query that lists all consultations in the first week of March 2012 ;

    //sqlQuestion[337] = Write a query that lists all consultations in the second week of March 2012 ;

    //sqlQuestion[338] = Write a query that lists all consultations in the third week of March 2012 ;

    //sqlQuestion[339] = Write a query that lists all consultations from the 22nd to the end of March 2012 ;

    //sqlQuestion[340] = Write a query that lists all consultations seen in March 2012 who had similarly entered complaints and similarly entered treatments in both months March 2012 and March 2013, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months ;

    //sqlQuestion[341] = Write a query that lists all the consultations seen in March 2012 who had similarly entered notes, similarly entered treatments or similarly entered date of births in March 2013 ;

    //sqlQuestion[342] = Write a query that lists all patients seen in March 2012 who have similar diagnosis as those seen in March 2013 ;

    //sqlQuestion[343] = Write a query that lists all consultations in March 2012 who have similar entries under treatments as the consultations seen in March 2013. Both years consultations must have entries under Notes ;

    //sqlQuestion[344] = Write a query that lists those seen in March 2012 who have similar complaints as those seen in March 2013 ;

    //sqlQuestion[345] = Write a query that lists all consultations seen in March 2012 who had similarly complaints entries as those seen in March 2013, both having consultation time of more than 10 minutes ;

    //sqlQuestion[346] = Write a query that lists all consultations seen in March 2012 who had similarly entered diagnosis as those seen in March 2013 ;

    //sqlQuestion[347] = Write a query that lists all those seen in March 2012 and March 2013 ;

    //sqlQuestion[348] = Write a query that lists all consultations seen in March 2012 who had entries of URTI under Diagnosis And patients seen in March 2013 who also had similar entries under Diagnosis ;

    //sqlQuestion[349] = Write a query that creates that enters no notes entry where there is no notes record entry else if there is entry put down the notes entry, for those seen in March 2012 ;

    //sqlQuestion[350] = Write a query that selects the last fifty seen appointments in March 2012 ;

    //sqlQuestion[351] = Write a query that lists the 20 earliest appointments in March 2012 ;

    //sqlQuestion[352] = Write a query that lists all patients seen in March 2013 whose notes entries contain the letter ‘C’ ;

    //sqlQuestion[353] = Write a query that displays all the consultations in March 2013 and March 2005 ;

    //sqlQuestion[354] = Write a query that lists all patients seen in March 2013 with entry under diagnosis, showing only the first ten records. The results are to be ordered by diagnosis in ascending order. These are for those seen in March 2013 and have similar diagnosis in March 2005 ;

    //sqlQuestion[355] = Write a query that lists appointments before 1050 hours and after 1730 hours in March 2013 ;

    //sqlQuestion[356] = Write a query that lists those seen in March 2013 who have similar complaints as those seen in March 2005 ;

    //sqlQuestion[357] = Write a query to list all those referred in March 2013 ;

    //sqlQuestion[358] = Write a query that lists all consultations in the first week of March 2013 ;

    //sqlQuestion[359] = Write a query that lists all consultations in the second week of March 2013 ;

    //sqlQuestion[360] = Write a query that lists all consultations in the third week of March 2013 ;

    //sqlQuestion[361] = Write a query that lists all consultations from the 22nd to the end of March 2013 ;

    //sqlQuestion[362] = "Write a query that lists all consultations seen in March 2013 who had similarly entered complaints and similarly entered treatments in both months March 2013 and

    Enjoying the preview?
    Page 1 of 1