The Making of a Doctor

By Julius Adebiyi Sodipo

Part One of Visual Basic.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.

• Language: English
• Publisher: Balboa Press UK
• Release date: Oct 27, 2021
• ISBN: 9781982284695

Book preview

Copyright © 2021 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 ([phone] 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-8468-8 (sc)

ISBN: 978-1-9822-8470-1 (hc)

ISBN: 978-1-9822-8469-5 (e)

Balboa Press rev. date:   10/27/2021

CONTENTS

Dedication

Appreciation

Aim

Introduction

Experience of a solo GP (virtually) Practice in suburban England (Visual Basic.Net coding) Part 1

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.

Experience of a solo

GP (virtually) Practice

in suburban England

(Visual Basic.Net coding)

Part 1

The GP Practice was in the East of England, close to the South East of England border. The period covered was in the late 1990s to early 20s, covering a period of just under 20 years.

The GP Practice was covered by two GPs and when the senior GP partner retired after about one year of the junior partner joining the Practice, the Practice was then solo run by the junior partner. Initially, for about 18 months out of hours cover was run by a co-operative of local GPs (so to say). The out of cover started from 7.00pm when the Surgeries close until 11.00pm, when the on-call doctor handed over to a commercially run out of hours service. Although the GPs handed over the care of their patients to the commercially run out of hours service, they were still ultimately responsible for their patients. The on-call service run by the local GPs was over the weekdays only. The weekends were covered by the commercially run service, that is Saturdays and Sundays.

Each GP Practice was responsible for paying its own fees to the commercial service, which was calculated based on the population of the list size of the Practice. There was a rota service between the local GPs which included cover for holidays or sicknesses, the latter involving more complicated arrangements. The on-call services by the GPs lasted for about 18 months when they all opted out of the out of hours service and the responsibilities for the patients during those hours was transferred to the government.

The information being presented were anonymously gathered by the GP, at the end of each day and entered the data into own created database, other than the names of the local GPs. No specific patient’s or patients’ identity can be traced from the information provided.

If you are interested in finding out more about the clinical experience of the GP, specific decisions taken during the approximately 20 years period of practice by the GP based on specific questions (or queries), please follow the instructions below.

PS: The instructions: -

1. To open the required file, for example, onCallConsultations.

A. Look for the D Drive and click on it.

B. Then look for the Data folder and click on it.

C. Then look for the Documents folder and click on it.

D. Then look for the Visual Studio 2015 and click on it.

E. Then look for the Visual Studio 2015 Projects folder and click on it.

a. Note that if Visual Studio 2015 is too old or not working, you may have to find a way of converting the 2015 file to the most modern one, for example Visual Studio 2019, which is also on this computer.

b. Other contemporary visual Studio program may first have to be downloaded from the Microsoft downloads website.

F. Look for onCallConsultations and click on it.

G. Then Right click on onCallConsultations.sln (i.e. the file with suffix .sln).

H. Click on open with Microsoft visual Studio Version Selector.

I. If there are no documents opened then right-click on the desired file, for example Form1.vb and click on view code.

a. Note that if you are looking to view or work on other consultations like AprilSurgeryConsultations, you do all the above and click on AprilSurgeryConsultations instead.

• AprilSurgeryConsultations covers surgery consultations from the start of April 1997 to April 2005. This is similar for all the other months from January to December without April of course.

• In AprilSurgeryConsultations and other consultations, queries 0 and 1 both run as query 1, i.e. the first query. I don’t know the reason(s) for this discrepancy. If I can correct this bug, I shall do so otherwise keep this in mind when running the programs.

• Similarly, April2006_2015SurgeryConsultations covers from the start of April 2006 to the end of April 2015. This is similar for all the other months from January to December without April of course.

• On the other hand, FebruarySurgeryConsultations covers consultations from the start of February 1997 to the end of February 2006.

• February 2007_2015SurgeryConsultations covers consultations from the start of February 2007 to the end of February 2015.

J. Then follow the instructions provided by the computer.

K. The file then loads up.

L. To run the program, click on the green bolded arrow just before Start at the top of the task bar or press F5.

M. Once the designed box loads up, the available fields or boxes are initially empty. Press the arrows and follow the instructions to get the results of the query. The empty boxes or fields will then be populated with data.

N. To stop and clear the box, click on the X at the top of right-hand corner. Or click on the Debug and click stop debugging.

2. Assuming you are interested to find out how many patients who were seen in April 2000 who had similar complaints as those seen in April 2001, you will need to open the AprilSurgeryConsultations project as described above. Once this is opened, then you can look at the sqlQuestion and sqlResult section. Scrutinizing these carefully will show you that they are both numbered 80. So, unfortunately you are limited by what questions set. Then where you see For m = a To m + n, where a is a number and has to be changed to 80 as in our case. You should change the value of a at the top of the sqlResult and sqlQuestion. If you want you can leave the number at the top of sqlResult 0 and only change the sqlQuestion number as required. It is therefore not absolutely important that the numbers are the same as the program should still run normally.

3. By the way if the program crashes, just click Debug and then click on stop debugging on dialog box that appears.

4. Once the program is run, just click on the forward arrow to show you the first record and you can then press on the other arrows as appropriate. The Query Result will show the result of the query that has been run. On the smaller form, Form2, click on the arrow at the right end which should show you a list of possible pre-set queries. Pick the one you have chosen and click okay which you a message box of what you have chosen.

5. The same thing can be done for any of the other projects, under visual basic programming.

6. You should ignore the Query List button, which should however not work.

7. If you are interested in on call queries, then click on the OnCallConsultations project and open the OnCallConsultations.sln as described above.

8. Assuming you are interested to find out how many patients who were seen out of hours in June 1997, you will need to open the OnCallConsultations project as described above. Once this is opened, then you can look at the sqlQuestion and sqlResult section and follow the instructions described above under 2.

9. Unfortunately, for the first question or result, number 0, and for the following question, i.e. number 0, the answer is for number 1. I am not sure what is causing this but if I am able to correct the bug in future, then I shall do so.

10. Don’t forget to close the first two boxes that appear on running the program. Close the small one first and then the bigger one and another box will appear showing empty results. If you close the bigger form first, that should cause both forms to be closed together. To get the first result you need to click the forward arrow (>) to bring the first result. The following: < bring up the previous record if there is any otherwise you will get a dialogue box giving you the appropriate information; << takes you to the first record and >> takes you to the last record.

11. If there are no records, when the forward arrow is clicked it will state that there are no rows.

12. If the program crashes, to re-activate this you should do the following: In this case you will need to re-activate the program before you can run it again. To do so, head for Debug at the status bar above, click on it and then click on Stop debugging.

13. As for form2, i.e. the combox that appears when the program is run. This should be ignored, unless I can figure out how to access data from the box to run the program as desired. Clicking on the X at the corner of Form 1 should close both forms. Otherwise you can click on Debug and then click on Stop Debugging.

14. Please note that if the result for the query is zero, you will get no more rows appear in a message box. Close the box by clicking okay or the x at the top. Clicking on the forward arrow will bring up the message box described above.

15. If there is no database record for the month then a message box stating that there is no record for the month will appear. This can be closed as usual. Clicking on the forward arrow of the empty form will result in the program crashing and trying to close the form by clicking on the x at the top of the form will not close it. To close the form you will need to click on Debug and then click on Stop Debugging.

Visual Basic.Net - Questions, Results, SQL Queries and Programming Codes

April 2006 to April 2015 Surgery Consultations Form1

Public Class Form1

Dim SecondForm As New Form2

Public Shared ComboText As String

Public Shared qryPresent As Boolean

Public Shared sqlQuestion(219)        ‘DECLARES sqlQuestion array.

Public Shared query(219) As String        ‘DECLARES query array.

Public Shared sqlResult(219) As String        ‘DECLARES sqlResult array.

Public Shared cb As ComboBox

Dim qryA As String

Dim QueryResult1 As String

Dim MaxRows As Integer

Dim inc As Integer

Dim m As Integer

Dim i As Integer

Dim z As Integer

Dim n As Integer

Dim key_data_sqlResult As String        ‘DECLARES THE VARIABLE key_data_query.

Dim key_data_query As String        ‘DECLARES THE VARIABLE key_sqlResult.

Dim con As New OleDb.OleDbConnection        ‘THE CONNECTION OBJECT

Dim dbProvider As String        ‘HOLDS THE PROVIDER

Dim dbSource As String        ‘HOLDS THE DATA SOURCE

Dim MyDocumentsFolder As String        ‘HOLDS THE DOCUMENTS FOLDER

Dim TheDatabase As String        ‘HOLDS THE DATABASE NAME

Dim FullDatabasePath As String        ‘HOLDS THE DATABASE PATH

Dim ds As New DataSet        ‘HOLDS A DataSet OBJECT

Dim da As OleDb.OleDbDataAdapter        ‘HOLDS A DataAdapter OBJECT

Dim sql As String        ‘HOLDS A SQL STRING

‘STORE QUERY RESULTS

‘sqlResult(0) = Patients seen in April 2006 whose notes entries contain the letter ‘C’

‘sqlResult(1) = Patients seen in April 2006 and in April 2007.

‘sqlResult(2) = Patients seen in April 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 April 2006 and have similar diagnosis in April 2007

‘sqlResult(3) = The appointments before 1050 hours and after 1730 hours in April 2006.

‘sqlResult(4) = Patients seen in April 2006 who have similar complaints as those seen in April 2007

‘sqlResult(5) = Patients referred in April 2006

‘sqlResult(6) = Patients seen in the first week of April 2006.

‘sqlResult(7) = Patients seen in the second week of April 2006.

‘sqlResult(8) = Patients seen in the third week of April 2006.

‘sqlResult(9) = "Patients seen from the 22nd to the end of April 2006."

‘sqlResult(10) = Patients seen in April 2006 who had similar entries under treatments as the patients seen in April 2007 And in both years had entries under Notes.

‘sqlResult(11) = Patients seen in April 2006 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2007.

‘sqlResult(12) = Patients seen in April 2006 who had similarly entered diagnosis as those seen in April 2007

‘sqlResult(13) = Patients seen in April 2006 who have similar entries under treatments as the consultations seen in April 2007 with both years of consultations having had entries under Notes

‘sqlResult(14) = Patients seen in April 2006 who have similar complaints as those seen in April 2007

‘sqlResult(15) = Patients seen in April 2006 who had similarly complaints entries as those seen in April 2007, both having consultation time of more than 10 minutes.

‘sqlResult(16) = Patients seen in April 2006 who had similarly entered diagnosis as those seen in April 2007.

‘sqlResult(17) = Patients seen in April 2006 and April 2007.

‘sqlResult(18) = Patients seen in April 2006 who had entries of URTI under Diagnosis and patients seen in April 2007 who also had similar entries under Diagnosis.

‘sqlResult(19) = Patients seen in April 2006 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(20) = The last fifty seen appointments in April 2006

‘sqlResult(21) = First twenty appointments in April 2006.

‘sqlResult(22) = Patients seen in April 2007 whose notes entries contain the letter ‘C’

‘sqlResult(23) = Patients seen in April 2007 and in April 2008.

‘sqlResult(24) = Patients seen in April 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 April 2007 and have similar diagnosis in April 2008

‘sqlResult(25) = The appointments before 1050 hours and after 1730 hours in April 2007.

‘sqlResult(26) = Patients seen in April 2007 who have similar complaints as those seen in April 2008

‘sqlResult(27) = Patients referred in April 2007.

‘sqlResult(28) = Patients seen in the first week of April 2007.

‘sqlResult(29) = Patients seen in the second week of April 2007.

‘sqlResult(30) = Patients seen in the third week of April 2007.

‘sqlResult(31) = "Patients seen from the 22nd to the end of April 2007."

‘sqlResult(32) = Patients seen in April 2007 who had similar entries under treatments as the patients seen in April 2008 and in both years had entries under Notes.

‘sqlResult(33) = Patients seen in April 2007 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2008.

‘sqlResult(34) = Patients seen in April 2007 who had similarly entered diagnosis as those seen in April 2008

‘sqlResult(35) = Patients seen in April 2007 who have similar entries under treatments as the consultations seen in April 2008 with both years of consultations having had entries under Notes

‘sqlResult(36) = Patients seen in April 2007 who have similar complaints as those seen in April 2008

‘sqlResult(37) = Patients seen in April 2007 who had similarly complaints entries as those seen in April 2008, both having consultation time of more than 10 minutes.

‘sqlResult(38) = Patients seen in April 2007 who had similarly entered diagnosis as those seen in April 2008.

‘sqlResult(39) = Patients seen in April 2007 and April 2008.

‘sqlResult(40) = Patients seen in April 2007 who had entries of URTI under Diagnosis and patients seen in April 2008 who also had similar entries under Diagnosis.

‘sqlResult(41) = Patients seen in April 2007 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(42) = The last fifty seen appointments in April 2007.

‘sqlResult(43) = First twenty appointments in April 2007.

‘sqlResult(44) = Patients seen in April 2008 whose notes entries contain the letter ‘C’

‘sqlResult(45) = Patients seen in April 2008 and in April 2009.

‘sqlResult(46) = Patients seen in April 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 April 2008 and have similar diagnosis in April 2009

‘sqlResult(47) = The appointments before 1050 hours and after 1730 hours in April 2008.

‘sqlResult(48) = Patients seen in April 2008 who have similar complaints as those seen in April 2009

‘sqlResult(49) = Patients referred in April 2008.

‘sqlResult(50) = Patients seen in the first week of April 2008.

‘sqlResult(51) = Patients seen in the second week of April 2008.

‘sqlResult(52) = Patients seen in the third week of April 2008.

‘sqlResult(53) = "Patients seen from the 22nd to the end of April 2008."

‘sqlResult(54) = Patients seen in April 2008 who had similar entries under treatments as the patients seen in April 2009 and in both years had entries under Notes.

‘sqlResult(55) = Patients seen in April 2008 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2009.

‘sqlResult(56) = Patients seen in April 2008 who had similarly entered diagnosis as those seen in April 2009

‘sqlResult(57) = Patients seen in April 2008 who have similar entries under treatments as the consultations seen in April 2009 with both years of consultations having had entries under Notes

‘sqlResult(58) = Patients seen in April 2008 who have similar complaints as those seen in April 2009

‘sqlResult(59) = Patients seen in April 2008 who had similarly complaints entries as those seen in April 2009, both having consultation time of more than 10 minutes.

‘sqlResult(60) = Patients seen in April 2008 who had similarly entered diagnosis as those seen in April 2009.

‘sqlResult(61) = Patients seen in April 2008 and April 2009.

‘sqlResult(62) = Patients seen in April 2008 who had entries of URTI under Diagnosis and patients seen in April 2009 who also had similar entries under Diagnosis.

‘sqlResult(63) = Patients seen in April 2008 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(64) = The last fifty seen appointments in April 2008.

‘sqlResult(65) = First twenty appointments in April 2008.

‘sqlResult(66) = Patients seen in April 2009 whose notes entries contain the letter ‘C’

‘sqlResult(67) = Patients seen in April 2009 and in April 2010.

‘sqlResult(68) = Patients seen in April 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 April 2009 and have similar diagnosis in April 2010

‘sqlResult(69) = The appointments before 1050 hours and after 1730 hours in April 2009.

‘sqlResult(70) = Patients seen in April 2009 who have similar complaints as those seen in April 2010

‘sqlResult(71) = Patients referred in April 2009.

‘sqlResult(72) = Patients seen in the first week of April 2009.

‘sqlResult(73) = Patients seen in the second week of April 2009.

‘sqlResult(74) = Patients seen in the third week of April 2009.

‘sqlResult(75) = "Patients seen from the 22nd to the end of April 2009."

‘sqlResult(76) = Patients seen in April 2009 who had similar entries under treatments as the patients seen in April 2010 and in both years had entries under Notes.

‘sqlResult(77) = Patients seen in April 2009 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2010.

‘sqlResult(78) = Patients seen in April 2009 who had similarly entered diagnosis as those seen in April 2010

‘sqlResult(79) = Patients seen in April 2009 who have similar entries under treatments as the consultations seen in April 2010 with both years of consultations having had entries under Notes

‘sqlResult(80) = Patients seen in April 2009 who have similar complaints as those seen in April 2010

‘sqlResult(81) = Patients seen in April 2009 who had similarly complaints entries as those seen in April 2010, both having consultation time of more than 10 minutes.

‘sqlResult(82) = Patients seen in April 2009 who had similarly entered diagnosis as those seen in April 2010.

‘sqlResult(83) = Patients seen in April 2009 and April 2010.

‘sqlResult(84) = Patients seen in April 2009 who had entries of URTI under Diagnosis and patients seen in April 2010 who also had similar entries under Diagnosis.

‘sqlResult(85) = Patients seen in April 2009 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(86) = The last fifty seen appointments in April 2009.

‘sqlResult(87) = First twenty appointments in April 2009.

‘sqlResult(88) = Patients seen in April 2010 whose notes entries contain the letter ‘C’

‘sqlResult(89) = Patients seen in April 2010 and in April 2011.

‘sqlResult(90) = Patients seen in April 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 April 2010 and have similar diagnosis in April 2011

‘sqlResult(91) = The appointments before 1050 hours and after 1730 hours in April 2010.

‘sqlResult(92) = Patients seen in April 2010 who have similar complaints as those seen in April 2011

‘sqlResult(93) = Patients referred in April 2010.

‘sqlResult(94) = Patients seen in the first week of April 2010.

‘sqlResult(95) = Patients seen in the second week of April 2010.

‘sqlResult(96) = Patients seen in the third week of April 2010.

‘sqlResult(97) = "Patients seen from the 22nd to the end of April 2010."

‘sqlResult(98) = Patients seen in April 2010 who had similar entries under treatments as the patients seen in April 2011 and in both years had entries under Notes.

‘sqlResult(99) = Patients seen in April 2010 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2011.

‘sqlResult(100) = Patients seen in April 2010 who had similarly entered diagnosis as those seen in April 2011

‘sqlResult(101) = Patients seen in April 2010 who have similar entries under treatments as the consultations seen in April 2011 with both years of consultations having had entries under Notes

‘sqlResult(102) = Patients seen in April 2010 who have similar complaints as those seen in April 2011

‘sqlResult(103) = Patients seen in April 2010 who had similarly complaints entries as those seen in April 2011, both having consultation time of more than 10 minutes.

‘sqlResult(104) = Patients seen in April 2010 who had similarly entered diagnosis as those seen in April 2011.

‘sqlResult(105) = Patients seen in April 2010 and April 2011.

‘sqlResult(106) = Patients seen in April 2010 who had entries of URTI under Diagnosis and patients seen in April 2011 who also had similar entries under Diagnosis.

‘sqlResult(107) = Patients seen in April 2010 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(108) = The last fifty seen appointments in April 2010.

‘sqlResult(109) = First twenty appointments in April 2010.

‘sqlResult(110) = Patients seen in April 2011 whose notes entries contain the letter ‘C’

‘sqlResult(111) = Patients seen in April 2011 and in April 2012.

‘sqlResult(112) = Patients seen in April 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 April 2011 and have similar diagnosis in April 2012

‘sqlResult(113) = The appointments before 1050 hours and after 1730 hours in April 2011.

‘sqlResult(114) = Patients seen in April 2011 who have similar complaints as those seen in April 2012

‘sqlResult(115) = Patients referred in April 2011.

‘sqlResult(116) = Patients seen in the first week of April 2011.

‘sqlResult(117) = Patients seen in the second week of April 2011.

‘sqlResult(118) = Patients seen in the third week of April 2011.

‘sqlResult(119) = "Patients seen from the 22nd to the end of April 2011."

‘sqlResult(120) = Patients seen in April 2011 who had similar entries under treatments as the patients seen in April 2012 and in both years had entries under Notes.

‘sqlResult(121) = Patients seen in April 2011 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2012.

‘sqlResult(122) = Patients seen in April 2011 who had similarly entered diagnosis as those seen in April 2012

‘sqlResult(123) = Patients seen in April 2011 who have similar entries under treatments as the consultations seen in April 2012 with both years of consultations having had entries under Notes

‘sqlResult(124) = Patients seen in April 2011 who have similar complaints as those seen in April 2012

‘sqlResult(125) = Patients seen in April 2011 who had similarly complaints entries as those seen in April 2012, both having consultation time of more than 10 minutes.

‘sqlResult(126) = Patients seen in April 2011 who had similarly entered diagnosis as those seen in April 2012.

‘sqlResult(127) = Patients seen in April 2011 and April 2012.

‘sqlResult(128) = Patients seen in April 2011 who had entries of URTI under Diagnosis and patients seen in April 2012 who also had similar entries under Diagnosis.

‘sqlResult(129) = Patients seen in April 2011 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(130) = The last fifty seen appointments in April 2011.

‘sqlResult(131) = First twenty appointments in April 2011.

‘sqlResult(132) = Patients seen in April 2012 whose notes entries contain the letter ‘C’

‘sqlResult(133) = Patients seen in April 2012 and in April 2013.

‘sqlResult(134) = Patients seen in April 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 April 2012 and have similar diagnosis in April 2013

‘sqlResult(135) = The appointments before 1050 hours and after 1730 hours in April 2012.

‘sqlResult(136) = Patients seen in April 2012 who have similar complaints as those seen in April 2013

‘sqlResult(137) = Patients referred in April 2012.

‘sqlResult(138) = Patients seen in the first week of April 2012.

‘sqlResult(139) = Patients seen in the second week of April 2012.

‘sqlResult(140) = Patients seen in the third week of April 2012.

‘sqlResult(141) = "Patients seen from the 22nd to the end of April 2012."

‘sqlResult(142) = Patients seen in April 2012 who had similar entries under treatments as the patients seen in April 2013 and in both years had entries under Notes.

‘sqlResult(143) = Patients seen in April 2012 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2013.

‘sqlResult(144) = Patients seen in April 2012 who had similarly entered diagnosis as those seen in April 2013

‘sqlResult(145) = Patients seen in April 2012 who have similar entries under treatments as the consultations seen in April 2013 with both years of consultations having had entries under Notes

‘sqlResult(146) = Patients seen in April 2012 who have similar complaints as those seen in April 2013

‘sqlResult(147) = Patients seen in April 2012 who had similarly complaints entries as those seen in April 2013, both having consultation time of more than 10 minutes.

‘sqlResult(148) = Patients seen in April 2012 who had similarly entered diagnosis as those seen in April 2013.

‘sqlResult(149) = Patients seen in April 2012 and April 2013.

‘sqlResult(150) = Patients seen in April 2012 who had entries of URTI under Diagnosis and patients seen in April 2013 who also had similar entries under Diagnosis.

‘sqlResult(151) = Patients seen in April 2012 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(152) = The last fifty seen appointments in April 2012.

‘sqlResult(153) = First twenty appointments in April 2012.

‘sqlResult(154) = Patients seen in April 2013 whose notes entries contain the letter ‘C’

‘sqlResult(155) = Patients seen in April 2013 and in April 2005.

‘sqlResult(156) = Patients seen in April 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 April 2013 and have similar diagnosis in April 2005

‘sqlResult(157) = The appointments before 1050 hours and after 1730 hours in April 2013.

‘sqlResult(158) = Patients seen in April 2013 who have similar complaints as those seen in April 2005

‘sqlResult(159) = Patients referred in April 2013.

‘sqlResult(160) = Patients seen in the first week of April 2013.

‘sqlResult(161) = Patients seen in the second week of April 2013.

‘sqlResult(162) = Patients seen in the third week of April 2013.

‘sqlResult(163) = "Patients seen from the 22nd to the end of April 2013."

‘sqlResult(164) = Patients seen in April 2013 who had similar entries under treatments as the patients seen in April 2005 and in both years had entries under Notes.

‘sqlResult(165) = Patients seen in April 2013 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2005.

‘sqlResult(166) = Patients seen in April 2013 who had similarly entered diagnosis as those seen in April 2005

‘sqlResult(167) = Patients seen in April 2013 who have similar entries under treatments as the consultations seen in April 2005 with both years of consultations having had entries under Notes

‘sqlResult(168) = Patients seen in April 2013 who have similar complaints as those seen in April 2005

‘sqlResult(169) = Patients seen in April 2013 who had similarly complaints entries as those seen in April 2005, both having consultation time of more than 10 minutes.

‘sqlResult(170) = Patients seen in April 2013 who had similarly entered diagnosis as those seen in April 2005.

‘sqlResult(171) = Patients seen in April 2013 and April 2005.

‘sqlResult(172) = Patients seen in April 2013 who had entries of URTI under Diagnosis and patients seen in April 2005 who also had similar entries under Diagnosis.

‘sqlResult(173) = Patients seen in April 2013 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(174) = The last fifty seen appointments in April 2013.

‘sqlResult(175) = First twenty appointments in April 2013.

‘sqlResult(176) = Patients seen in April 2014 whose notes entries contain the letter ‘C’

‘sqlResult(177) = Patients seen in April 2014 and in April 2015.

‘sqlResult(178) = Patients seen in April 2014 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 April 2014 and have similar diagnosis in April 2015

‘sqlResult(179) = The appointments before 1050 hours and after 1730 hours in April 2014.

‘sqlResult(180) = Patients seen in April 2014 who have similar complaints as those seen in April 2015

‘sqlResult(181) = Patients referred in April 2014.

‘sqlResult(182) = Patients seen in the first week of April 2014.

‘sqlResult(183) = Patients seen in the second week of April 2014.

‘sqlResult(184) = Patients seen in the third week of April 2014.

‘sqlResult(185) = "Patients seen from the 22nd to the end of April 2014."

‘sqlResult(186) = Patients seen in April 2014 who had similar entries under treatments as the patients seen in April 2015 and in both years had entries under Notes.

‘sqlResult(187) = Patients seen in April 2014 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2015.

‘sqlResult(188) = Patients seen in April 2014 who had similarly entered diagnosis as those seen in April 2015

‘sqlResult(189) = Patients seen in April 2014 who have similar entries under treatments as the consultations seen in April 2015 with both years of consultations having had entries under Notes

‘sqlResult(190) = Patients seen in April 2014 who have similar complaints as those seen in April 2015

‘sqlResult(191) = Patients seen in April 2014 who had similarly complaints entries as those seen in April 2015, both having consultation time of more than 10 minutes.

‘sqlResult(192) = Patients seen in April 2014 who had similarly entered diagnosis as those seen in April 2015.

‘sqlResult(193) = Patients seen in April 2014 and April 2015.

‘sqlResult(194) = Patients seen in April 2014 who had entries of URTI under Diagnosis and patients seen in April 2015 who also had similar entries under Diagnosis.

‘sqlResult(195) = Patients seen in April 2014 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(196) = The last fifty seen appointments in April 2014.

‘sqlResult(197) = First twenty appointments in April 2014.

‘sqlResult(198) = Patients seen in April 2015 whose notes entries contain the letter ‘C’

‘sqlResult(199) = Patients seen in April 2015 and in April 2006.

‘sqlResult(200) = Patients seen in April 2015 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 April 2015 and have similar diagnosis in April 2006

‘sqlResult(201) = The appointments before 1050 hours and after 1730 hours in April 2015.

‘sqlResult(202) = Patients seen in April 2015 who have similar complaints as those seen in April 2006

‘sqlResult(203) = Patients referred in April 2015.

‘sqlResult(204) = Patients seen in the first week of April 2015.

‘sqlResult(205) = Patients seen in the second week of April 2015.

‘sqlResult(206) = Patients seen in the third week of April 2015.

‘sqlResult(207) = "Patients seen from the 22nd to the end of April 2015."

‘sqlResult(208) = Patients seen in April 2015 who had similar entries under treatments as the patients seen in April 2006 and in both years had entries under Notes.

‘sqlResult(209) = Patients seen in April 2015 who had similarly entered notes, similarly entered treatments or similarly entered date of births in April 2006.

‘sqlResult(210) = Patients seen in April 2015 who had similarly entered diagnosis as those seen in April 2006

‘sqlResult(211) = Patients seen in April 2015 who have similar entries under treatments as the consultations seen in April 2006 with both years of consultations having had entries under Notes

‘sqlResult(212) = Patients seen in April 2015 who have similar complaints as those seen in April 2006

‘sqlResult(213) = Patients seen in April 2015 who had similarly complaints entries as those seen in April 2006, both having consultation time of more than 10 minutes.

‘sqlResult(214) = Patients seen in April 2015 who had similarly entered diagnosis as those seen in April 2006.

‘sqlResult(215) = Patients seen in April 2015 and April 2006.

‘sqlResult(216) = Patients seen in April 2015 who had entries of URTI under Diagnosis and patients seen in April 2006 who also had similar entries under Diagnosis.

‘sqlResult(217) = Patients seen in April 2015 showing the notes column with no record entry provided they originally had nothing entered.

‘sqlResult(218) = The last fifty seen appointments in April 2015.

‘sqlResult(219) = First twenty appointments in April 2015.

‘STORE THE SQL String

‘1 Write a query that lists all patients seen in April 2006 whose notes entries contain the letter ‘C’

‘2 Write a query that displays all the consultations in April 2006 And April 2007

‘3 Write a query that lists all patients seen in April 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 April 2006 And have similar diagnosis in April 2007

‘4 Write a query that lists appointments before 1050 hours And after 1730 hours in April 2006

‘5 Write a query that lists those seen in April 2006 who have similar complaints as those seen in April 2007

‘6 Write a query to list all those referred in April 2006

‘7 Write a query that lists all consultations in the first week of April 2006

‘8 Write a query that lists all consultations in the second week of April 2006

‘9 Write a query that lists all consultations in the third week of April 2006

‘10 Write a query that lists all consultations from the 22nd to the end of April 2006

‘11 Write a query that lists all the consultations in April 2006 who had similar entries under treatments As the consultations seen In April 2007. Both years consultations must have entries under Notes

‘12 Write a query that lists all the consultations seen in April 2006 who had similarly entered notes, similarly entered treatments Or similarly entered date of births in April 2007

‘13 Write a query that lists all patients seen in April 2006 who have similar diagnosis as those seen in April 2007

‘14 Write a query that lists all consultations in April 2006 who have similar entries under treatments as the consultations seen in April 2007. Both years consultations must have entries under Notes

‘15 Write a query that lists those seen in April 2006 who have similar complaints as those seen in April 2007

‘16 Write a query that lists all consultations seen in April 2006 who had similarly complaints entries as those seen in April 2007, both having consultation time of more than 10 minutes

‘17 Write a query that lists all consultations seen in April 2006 who had similarly entered diagnosis as those seen in April 2007

‘18 Write a query that lists all those seen in April 2006 And April 2007

‘19 Write a query that lists all consultations seen in April 2006 who had entries of URTI under Diagnosis And patients seen in April 2007 who also had similar entries under Diagnosis

‘20 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 April 2006

‘21 Write a query that selects the last fifty seen appointments in April 2006

‘22 Write a query that lists the 20 earliest appointments in April 2006

‘23 Write a query that lists all patients seen in April 2007 whose notes entries contain the letter ‘C’

‘24 Write a query that displays all the consultations in April 2007 And April 2008

‘25 Write a query that lists all patients seen in April 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 April 2007 And have similar diagnosis in April 2008

‘26 Write a query that lists appointments before 1050 hours And after 1730 hours in April 2007

‘27 Write a query that lists those seen in April 2007 who have similar complaints as those seen in April 2008

‘28 Write a query to list all those referred in April 2007

‘29 Write a query that lists all consultations in the first week of April 2007

‘30 Write a query that lists all consultations in the second week of April 2007

‘31 Write a query that lists all consultations in the third week of April 2007

‘32 Write a query that lists all consultations from the 22nd to the end of April 2007

‘33 Write a query that lists all consultations seen in April 2007 who had similarly entered complaints And similarly entered treatments in both months April 2007 And April 2008, but the notes entries in both months are Not similar, And there are entries under complaints, treatments, notes And diagnosis in both months

‘34 Write a query that lists all the consultations seen in April 2007 who had similarly entered notes, similarly entered treatments Or similarly entered date of births in April 2008

‘35 Write a query that lists all patients seen in April 2007 who have similar diagnosis as those seen in April 2008

‘36 Write a query that lists all consultations in April 2007 who have similar entries under treatments as the consultations seen in April 2008. Both years consultations must have entries under Notes

‘37 Write a query that lists those seen in April 2007 who have similar complaints as those seen in April 2008

‘38 Write a query that lists all consultations seen in April 2007 who had similarly complaints entries as those seen in April 2008, both having consultation time of more than 10 minutes

‘39 Write a query that lists all consultations seen in April 2007 who had similarly entered diagnosis as those seen in April 2008

‘40 Write a query that lists all those seen in April 2007 And April 2008

‘41 Write a query that lists all consultations seen in April 2007 who had entries of URTI under Diagnosis And patients seen in April 2008 who also had similar entries under Diagnosis

‘42 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 April 2007

‘43 Write a query that selects the last fifty seen appointments in April 2007

‘44 Write a query that lists the 20 earliest appointments in April 2007

‘45 Write a query that lists all patients seen in April 2008 whose notes entries contain the letter ‘C’

‘46 Write a query that displays all the consultations in April 2008 And April 2009

‘47 Write a query that lists all patients seen in April 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 April 1997 And have similar diagnosis in April 1998

‘48 Write a query that lists appointments before 1050 hours And after 1730 hours in April 2008

‘49 Write a query that lists those seen in April 2008 who have similar complaints as those seen in April 1998

‘50 Write a query to list all those referred in April 2008

‘51 Write a query that lists all consultations in the first week of April 2008

‘52 Write a query that lists all consultations in the second week of April 2008

‘53 Write a query that lists all consultations in the third week of April 2008

‘54 Write a query that lists all consultations from the 22nd to the end of April 2008

‘55 Write a query that lists all consultations seen in April 2008 who had similarly entered complaints And similarly entered treatments in both months April 2008 And April 2009, but the notes entries in both months are Not similar, And there are entries under complaints, treatments, notes And diagnosis in both months

‘56 Write a query that lists all the consultations seen in April 2008 who had similarly entered notes, similarly entered treatments Or similarly entered date of births in April 1998

‘57 Write a query that lists all patients seen in April 2008 who have similar diagnosis as those seen in April 1998

‘58 Write a query that lists all consultations in April 2008 who have similar entries under treatments as the consultations seen in April 1998. Both years consultations must have entries under Notes

‘59 Write a query that lists those seen in April 2008 who have similar complaints as those seen in April 1998

‘60 Write a query that lists all consultations seen in April 2008 who had similarly complaints entries as those seen in April 1998, both having consultation time of more than 10 minutes

‘61 Write a query that lists all consultations seen in April 2008 who had similarly entered diagnosis as those seen in April 1998

‘62 Write a query that lists all those seen in April 2008 And April 1998

‘63 Write a query that lists all consultations seen in April 2008 who had entries of URTI under Diagnosis And patients seen in April 1998 who also had similar entries under Diagnosis

‘64 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 April 2008

‘65 Write a query that selects the last fifty seen appointments in April 2008

‘66 Write a query that lists the 20 earliest appointments in April 2008

‘67 Write a query that lists all patients seen in April 2009 whose notes entries contain the letter ‘C’

‘68 Write a query that displays all the consultations in April 2009 And April 2010

‘69 Write a query that lists all patients seen in April 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 April 2009 And have similar diagnosis in April 2010

‘70 Write a query that lists appointments before 1050 hours And after 1730 hours in April 2009

‘71 Write a query that lists those seen in April 2009 who have similar complaints as those seen in April 2010

‘72 Write a query to list all those referred in April 2009

‘73 Write a query that lists all consultations in the first week of April 2009

‘74 Write a query that lists all consultations in the second week of April 2009

‘75 Write a query that lists all consultations in the third week of April 2009

‘76 Write a query that lists all consultations from the 22nd to the end of April 2009

‘77 Write a query that lists all consultations seen in April 2009 who had similarly entered complaints And similarly entered treatments in both months April 2009 And April 2010, but the notes entries in both months are Not similar, And there are entries under complaints, treatments, notes And diagnosis in both months

‘78 Write a query that lists all the consultations seen in April 2009 who had similarly entered notes, similarly entered treatments Or similarly entered date of births in April 2010

‘79 Write a query that lists all patients seen in April 2009 who have similar diagnosis as those seen in April 2010

‘80 Write a query that lists all consultations in April 2009 who have similar entries under treatments as the consultations seen in April 2010. Both years consultations must have entries under Notes

‘81 Write a query that lists those seen in April 2009 who have similar complaints as those seen in April 2010

‘82 Write a query that lists all consultations seen in April 2009 who had similarly complaints entries as those seen in April 2010, both having consultation time of more than 10 minutes

‘83 Write a query that lists all consultations seen in April 2009 who had similarly entered diagnosis as those seen in April 2010

‘84 Write a query that lists all those seen in April 2009 And April 2010

‘85 Write a query that lists all consultations seen in April 2009 who had entries of URTI under Diagnosis And patients seen in April 2010 who also had similar entries under Diagnosis

‘86 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 April 2009

‘87 Write a query that selects the last fifty seen appointments in April 2009

‘88 Write a query that lists the 20 earliest appointments in April 2009

‘89 Write a query that lists all patients seen in April 2010 whose notes entries contain the letter ‘C’

‘90 Write a query that displays all the consultations in April 2010 And April 2011

‘91 Write a query that lists all patients seen in April 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 April 2010 And have similar diagnosis in April 2011

‘92 Write a query that lists appointments before 1050 hours And after 1730 hours in April 2010

‘93 Write a query that lists those seen in April 2010 who have similar complaints as those seen in April 2011

‘94 Write a query to list all those referred in April 2010

‘95 Write a query that lists all consultations in the first week of April 2010

‘96 Write a query that lists all consultations in the second week of April 2010

‘97 Write a query that lists all consultations in the third week of April 2010

‘98 Write a query that lists all consultations from the 22nd to the end of April 2010

‘99 Write a query that lists all consultations seen in April 2010 who had similarly entered complaints And similarly entered treatments in both months April 2010 And April 2011, but the notes entries in both months are Not similar, And there are entries under complaints, treatments, notes And diagnosis in both months

‘100 Write a query that lists all the consultations seen in April 2010 who had similarly entered notes, similarly entered treatments Or similarly entered date of births in April 2011

‘101 Write a query that lists all patients seen in April 2010 who have similar diagnosis as those seen in April 2011

‘102 Write a query that lists all consultations in April 2010 who have similar entries under treatments as the consultations seen in April 2011. Both years consultations must have entries under Notes

‘103 Write a query that lists those seen in April 2010 who have similar complaints as those seen in April 2011

‘104 Write a query that lists all consultations seen in April 2010 who had similarly complaints entries as those seen in April 2011, both having consultation time of more than 10 minutes

‘105 Write a query that lists all consultations seen in April 2010 who had similarly entered diagnosis as those seen in April 2011

‘106 Write a query that lists all those seen in April 2010 And April 2011

‘107 Write a query that lists all consultations seen in April 2010 who had entries of URTI under Diagnosis And patients seen in April 2011 who also had similar entries under Diagnosis

‘108 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 April 2010

‘109 Write a query that selects the last fifty seen appointments in April 2010

‘110 Write a query that lists the 20 earliest appointments in April 2010

‘111 Write a query that lists all patients seen in April 2011 whose notes entries contain the letter ‘C’

‘112 Write a query that displays all the consultations in April 2011 And April 2012

‘113 Write a query that lists all patients seen in April 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 April 2011 And have similar diagnosis in April 2012

‘114 Write a query that lists appointments before 1050 hours And after 1730 hours in April 2011

‘115 Write a query that lists those seen in April 2011 who have similar complaints as those seen in April 2012

‘116 Write a query to list all those referred in April 2011

‘117 Write a query that lists all consultations in the first week of April 2011

‘118 Write a query that lists all consultations in the second week of April 2011

‘119 Write a query that lists all consultations in the third week of April 2011

‘120 Write a query that lists all consultations from the 22nd to the end of April 2011

‘121 Write a query that lists all consultations seen in April 2011 who had similarly entered complaints And similarly entered treatments in both months April 2011 And April 2012, but the notes entries in both months are Not similar, And there are entries under complaints, treatments, notes And diagnosis in both months

‘122 Write a query that lists all the consultations seen in April 2011 who had similarly entered notes, similarly entered treatments Or similarly entered date of births in April 2012

‘123 Write a query that lists all patients seen in April 2011 who have similar diagnosis as those seen in April 2012

‘124 Write a query that lists all consultations in April 2011 who have similar entries under treatments as the consultations seen in April 2012. Both years consultations must have entries under Notes

‘125 Write a query that lists those seen in April 2011 who have similar complaints as those seen in April 2012

‘126 Write a query that lists all consultations seen in April 2011 who had similarly complaints entries as those seen in April 2012, both having consultation time of more than 10 minutes

‘127 Write a query that lists all consultations seen in April 2011 who had similarly entered diagnosis as those seen in April 2012

‘128 Write a query that lists all those seen in April 2011 And April 2012

‘129 Write a query that lists all consultations seen in April 2011 who had entries of URTI under Diagnosis And patients seen in April 2012 who also had similar entries under Diagnosis

‘130 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 April 2011

‘131 Write a query that selects the last fifty seen appointments in April 2011

‘132 Write a query that lists the 20 earliest appointments in April 2011

‘133 Write a query that lists all patients seen in April 2012 whose notes entries contain the letter ‘C’

‘134 Write a query that displays all the consultations in April 2012 And April 2013

‘135 Write a query that lists all patients seen in April 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 April 2012 And have similar diagnosis in April 2013

‘136 Write a query that lists appointments before 1050 hours And after 1730 hours in April 2012

‘137 Write a query that lists those seen in April 2012 who have similar complaints as those seen in April 2013

‘138 Write a query to list all those referred in April 2012

‘139 Write a query that lists all consultations in the first week of April 2012

‘140 Write a query that lists all consultations in the second week of April 2012

‘141 Write a query that lists all consultations in the third week of April 2012

‘142 Write a query that lists all consultations from the 22nd to the end of April 2012

‘143 Write a query that lists all consultations seen in April 2012 who had similarly entered complaints And similarly