The Making of a Doctor
()
About this ebook
Read more from Julius Adebiyi Sodipo
The Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratings
Related to The Making of a Doctor
Related ebooks
The Making of a Doctor Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Part 2: The Sequel Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Part 2 Rating: 0 out of 5 stars0 ratingsThe Making of a Doctor Rating: 0 out of 5 stars0 ratingsSelf-Managed Superannuation in Retirement: a Personal History Through the Global Financial Crisis Rating: 0 out of 5 stars0 ratingsDon't Die Broke: Easy Steps on How to Save, Invest and Build Your Wealth Rating: 0 out of 5 stars0 ratingsHow Much Income Do I Really Need in Retirement? Rating: 0 out of 5 stars0 ratingsHow to Save and Invest for Retirement Rating: 0 out of 5 stars0 ratingsHow to Read & Understand Financial Statements When You Don't Know What You Are Looking At: For Business Owners and Investors Rating: 0 out of 5 stars0 ratingsDr. Ace's Guide to Personal and Financial Freedom: 2023 Edition Fully Revised and Updated Rating: 0 out of 5 stars0 ratingsShould My Asset Allocation Include My Pension and Social Security? Rating: 0 out of 5 stars0 ratingsThe Meaningful Retirement Guide: A Time-Tested Path to Financial and Social Relevance for Every Worker. Rating: 0 out of 5 stars0 ratingsDIY Personal Cash Flow Statement Rating: 5 out of 5 stars5/5Saving and Investing: Financial Knowledge and Financial Literacy That Everyone Needs and Deserves to Have! Rating: 0 out of 5 stars0 ratingsThe Dentist Guide to Creating Personal and Financial Freedom: 2023 Edition Fully Revised and Updated Rating: 0 out of 5 stars0 ratingsIRAs, 401(k)s & Other Retirement Plans: Strategies for Taking Your Money Out Rating: 4 out of 5 stars4/5401(K)—The Path to a Prosperous Retirement: Avoid the Traps. Find the Money. Rating: 0 out of 5 stars0 ratingsGuide to Personal Financial Planning for the Armed Forces Rating: 0 out of 5 stars0 ratingsDr. Ace's Guide to Personal and Financial Freedom Rating: 0 out of 5 stars0 ratingsDecoding the CashFlow Algorithm: Wealth & CashFlow Rating: 5 out of 5 stars5/5The Pledge: Your Master Plan for an Abundant Life Rating: 5 out of 5 stars5/5To Buy or to Rent: That is the Question. The Great Australian Dream, Fact or Fiction. Rating: 0 out of 5 stars0 ratingsWhat Your Banker Wont Tell You Rating: 0 out of 5 stars0 ratingsFinance for Non-Financiers 4: Special Finances Rating: 0 out of 5 stars0 ratingsThe Great Depression of Debt: Survival Techniques for Every Investor Rating: 4 out of 5 stars4/57Twelve: A Diversified Investment Portfolio with a Plan Rating: 5 out of 5 stars5/5Financial Strategies for the Successful Physician: Helping Successful People Continue Toward Their Life's Goals Rating: 0 out of 5 stars0 ratingsFinances - Fundamental Philosophy - Never Lose Money Rating: 0 out of 5 stars0 ratings
Medical For You
The Diabetes Code: Prevent and Reverse Type 2 Diabetes Naturally Rating: 4 out of 5 stars4/5The Vagina Bible: The Vulva and the Vagina: Separating the Myth from the Medicine Rating: 5 out of 5 stars5/5The Lost Book of Simple Herbal Remedies: Discover over 100 herbal Medicine for all kinds of Ailment Inspired By Barbara O'Neill Rating: 0 out of 5 stars0 ratingsMediterranean Diet Meal Prep Cookbook: Easy And Healthy Recipes You Can Meal Prep For The Week Rating: 5 out of 5 stars5/5What Happened to You?: Conversations on Trauma, Resilience, and Healing Rating: 4 out of 5 stars4/5Holistic Herbal: A Safe and Practical Guide to Making and Using Herbal Remedies Rating: 4 out of 5 stars4/5The Hormone Reset Diet: Heal Your Metabolism to Lose Up to 15 Pounds in 21 Days Rating: 4 out of 5 stars4/5The 40 Day Dopamine Fast Rating: 4 out of 5 stars4/5Period Power: Harness Your Hormones and Get Your Cycle Working For You Rating: 4 out of 5 stars4/5Rewire Your Brain: Think Your Way to a Better Life Rating: 4 out of 5 stars4/5Adult ADHD: How to Succeed as a Hunter in a Farmer's World Rating: 4 out of 5 stars4/5The Amazing Liver and Gallbladder Flush Rating: 5 out of 5 stars5/5The Art of Dying Well: A Practical Guide to a Good End of Life Rating: 4 out of 5 stars4/5Gut: The Inside Story of Our Body's Most Underrated Organ (Revised Edition) Rating: 4 out of 5 stars4/5Tight Hip Twisted Core: The Key To Unresolved Pain Rating: 4 out of 5 stars4/5Herbal Healing for Women Rating: 4 out of 5 stars4/5Working Stiff: Two Years, 262 Bodies, and the Making of a Medical Examiner Rating: 4 out of 5 stars4/5Healthy Gut, Healthy You: The Personalized Plan to Transform Your Health from the Inside Out Rating: 4 out of 5 stars4/5The Song of the Cell: An Exploration of Medicine and the New Human Rating: 4 out of 5 stars4/5Women With Attention Deficit Disorder: Embrace Your Differences and Transform Your Life Rating: 5 out of 5 stars5/5ATOMIC HABITS:: How to Disagree With Your Brain so You Can Break Bad Habits and End Negative Thinking Rating: 5 out of 5 stars5/5Summary of Dr. Gundry's Diet Evolution: Turn off the Genes That Are Killing You and Your Waistline Rating: 3 out of 5 stars3/5Woman: An Intimate Geography Rating: 4 out of 5 stars4/5Hidden Lives: True Stories from People Who Live with Mental Illness Rating: 4 out of 5 stars4/5
Reviews for The Making of a Doctor
0 ratings0 reviews
Book preview
The Making of a Doctor - Julius Adebiyi Sodipo
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 (+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-8465-7 (sc)
ISBN: 978-1-9822-8467-1 (hc)
ISBN: 978-1-9822-8466-4 (e)
Balboa Press rev. date: 10/21/2021
CONTENTS
Dedication
Appreciation
Aim
Introduction
Experience of a solo GP (virtually) Practice in suburban England (PHP coding) Part 2
Combo Box December 1997 to December 2005 Queries
December 1997 to December 2005 Surgery Database A
Combo Box December 1997 to December 2005 Queries
December 2006 to December 2015 Surgery Database A
Combo Box February 1997 to February 2006 Queries
February 1997 to February 2006 Surgery Database A
Combo Box February 2007 to February 2015 Queries
February 2007 to February 2015 Surgery Database A
Combo Box January 1997 to January 2006 Queries
January 1997 to January 2006 Surgery Database A
Combo Box April 2007 to April 2015 Queries
January 2007 to January 2015 Surgery Database A
Combo Box July 1997 to July 2005 Queries
July 1997 to July 2005 Surgery Database A
Combo Box July 2006 to July 2015 Queries
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 (PHP coding) Part 2
//USING FOR LOOP TO KNOW EXACTLY WHAT IS IN THE $sqlQuestion ARRAY & PICKING THE APPROPRIATE ONE
for ($m = 0; $m <= $n; $m++){
$sqlQuestion[0] =Write a query that lists all patients seen in August 2006 whose notes entries contain the letter ‘C’
;
$sqlQuestion[1] =Write a query that lists all patients seen in August 2007 whose notes entries contain the letter ‘C’
;
$sqlQuestion[2] =Write a query that lists all patients seen in August 2008 whose notes entries contain the letter ‘C’
;
$sqlQuestion[3] =Write a query that lists all patients seen in August 2009 whose notes entries contain the letter ‘C’
;
$sqlQuestion[4] =Write a query that lists all patients seen in August 2010 whose notes entries contain the letter ‘C’
;
$sqlQuestion[5] =Write a query that lists all patients seen in August 2011 whose notes entries contain the letter ‘C’
;
$sqlQuestion[6] =Write a query that lists all patients seen in August 2012 whose notes entries contain the letter ‘C’
;
$sqlQuestion[7] =Write a query that lists all patients seen in August 2013 whose notes entries contain the letter ‘C’
;
$sqlQuestion[8] =Write a query that lists all patients seen in August 2014 whose notes entries contain the letter ‘C’
;
$sqlQuestion[9] =Write a query that lists all patients seen in August 2015 whose notes entries contain the letter ‘C’
;
$sqlQuestion[10] =Write a query that lists all patients seen in August 2006 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2007
;
$sqlQuestion[11] =Write a query that lists all patients seen in August 2007 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2008
;
$sqlQuestion[12] =Write a query that lists all patients seen in August 2008 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2009
;
$sqlQuestion[13] =Write a query that lists all patients seen in August 2009 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2010
;
$sqlQuestion[14] =Write a query that lists all patients seen in August 2010 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2011
;
$sqlQuestion[15] =Write a query that lists all patients seen in August 2011 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2012
;
$sqlQuestion[16] =Write a query that lists all patients seen in August 2012 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2013
;
$sqlQuestion[17] =Write a query that lists all patients seen in August 2013 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2014
;
$sqlQuestion[18] =Write a query that lists all patients seen in August 2014 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2015
;
$sqlQuestion[19] =Write a query that lists all patients seen in August 2015 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2006
;
$sqlQuestion[20] =Write a query that lists all patients seen in August 2015 who have similarly diagnosis as those seen in August 2014
;
$sqlQuestion[21] =Write a query that lists all patients seen in August 2014 who have similarly diagnosis as those seen in August 2013
;
$sqlQuestion[22] =Write a query that lists all patients seen in August 2013 who have similarly diagnosis as those seen in August 2012
;
$sqlQuestion[23] =Write a query that lists all patients seen in August 2012 who have similarly diagnosis as those seen in August 2011
;
$sqlQuestion[24] =Write a query that lists all patients seen in August 2011 who have similarly diagnosis as those seen in August 2010
;
$sqlQuestion[25] =Write a query that lists all patients seen in August 2010 who have similarly diagnosis as those seen in August 2009
;
$sqlQuestion[26] =Write a query that lists all patients seen in August 2009 who have similarly diagnosis as those seen in August 2008
;
$sqlQuestion[27] =Write a query that lists all patients seen in August 2008 who have similarly diagnosis as those seen in August 2007
;
$sqlQuestion[28] =Write a query that lists all patients seen in August 2007 who have similarly diagnosis as those seen in August 2006
;
$sqlQuestion[29] =Write a query that lists all patients seen in August 2006 who have similarly diagnosis as those seen in August 2015
;
$sqlQuestion[30] =Write a query that lists all consultations seen in August 2015 who had similarly entered complaints and similarly entered treatments in both months, August 2015 and August 2014, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[31] =Write a query that lists all consultations seen in August 2014 who had similarly entered complaints and similarly entered treatments in both months, August 2014 and August 2013, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[32] =Write a query that lists all consultations seen in August 2013 who had similarly entered complaints and similarly entered treatments in both months, August 2013 and August 2012, but the notes entered 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 consultations seen in August 2012 who had similarly entered complaints and similarly entered treatments in both months, August 2012 and August 2011, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[34] =Write a query that lists all consultations seen in August 2011 who had similarly entered complaints and similarly entered treatments in both months, August 2011 and August 2010, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[35] =Write a query that lists all consultations seen in August 2010 who had similarly entered complaints and similarly entered treatments in both months, August 2010 and August 2009, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[36] =Write a query that lists all consultations seen in August 2009 who had similarly entered complaints and similarly entered treatments in both months, August 2009 and August 2008, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[37] =Write a query that lists all consultations seen in August 2008 who had similarly entered complaints and similarly entered treatments in both months, August 2008 and August 2007, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[38] =Write a query that lists all consultations seen in August 2007 who had similarly entered complaints and similarly entered treatments in both months, August 2007 and August 2006, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[39] =Write a query that lists all consultations seen in August 2006 who had similarly entered complaints and similarly entered treatments in both months, August 2006 and August 2015, but the notes entered in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[40] =Write a query that lists all patients seen in August 2015 who had similarly complaints entries as those seen in August 2014, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[41] =Write a query that lists all patients seen in August 2014 who had similarly complaints entries as those seen in August 2013, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[42] =Write a query that lists all patients seen in August 2013 who had similarly complaints entries as those seen in August 2012, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[43] =Write a query that lists all patients seen in August 2012 who had similarly complaints entries as those seen in August 2011, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[44] =Write a query that lists all patients seen in August 2011 who had similarly complaints entries as those seen in August 2010, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[45] =Write a query that lists all patients seen in August 2010 who had similarly complaints entries as those seen in August 2009, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[46] =Write a query that lists all patients seen in August 2009 who had similarly complaints entries as those seen in August 2008, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[47] =Write a query that lists all patients seen in August 2008 who had similarly complaints entries as those seen in August 2007, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[48] =Write a query that lists all patients seen in August 2007 who had similarly complaints entries as those seen in August 2006, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[49] =Write a query that lists all patients seen in August 2006 who had similarly complaints entries as those seen in August 2015, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[50] =Write a query that lists all patients seen in August 2015 and August 2014
;
$sqlQuestion[51] =Write a query that lists all patients seen in August 2014 and August 2013
;
$sqlQuestion[52] =Write a query that lists all patients seen in August 2013 and August 2012
;
$sqlQuestion[53] =Write a query that lists all patients seen in August 2012 and August 2011
;
$sqlQuestion[54] =Write a query that lists all patients seen in August 2011 and August 2010
;
$sqlQuestion[55] =Write a query that lists all patients seen in August 2010 and August 2009
;
$sqlQuestion[56] =Write a query that lists all patients seen in August 2009 and August 2008
;
$sqlQuestion[57] =Write a query that lists all patients seen in August 2008 and August 2007
;
$sqlQuestion[58] =Write a query that lists all patients seen in August 2007 and August 2006
;
$sqlQuestion[59] =Write a query that lists all patients seen in August 2006 and August 2015
;
$sqlQuestion[60] =Write a query that lists all consultations seen in August 2015 who had entries of URTI under Diagnosis and those seen in August 2014 who also had similar entries under Diagnosis
;
$sqlQuestion[61] =Write a query that lists all consultations seen in August 2014 who had entries of URTI under Diagnosis and those seen in August 2013 who also had similar entries under Diagnosis
;
$sqlQuestion[62] =Write a query that lists all consultations seen in August 2013 who had entries of URTI under Diagnosis and those seen in August 2012 who also had similar entries under Diagnosis
;
$sqlQuestion[63] =Write a query that lists all consultations seen in August 2012 who had entries of URTI under Diagnosis and those seen in August 2011 who also had similar entries under Diagnosis
;
$sqlQuestion[64] =Write a query that lists all consultations seen in August 2011 who had entries of URTI under Diagnosis and those seen in August 2010 who also had similar entries under Diagnosis
;
$sqlQuestion[65] =Write a query that lists all consultations seen in August 2010 who had entries of URTI under Diagnosis and those seen in August 2009 who also had similar entries under Diagnosis
;
$sqlQuestion[66] =Write a query that lists all consultations seen in August 2009 who had entries of URTI under Diagnosis and those seen in August 2008 who also had similar entries under Diagnosis
;
$sqlQuestion[67] =Write a query that lists all consultations seen in August 2008 who had entries of URTI under Diagnosis and those seen in August 2007 who also had similar entries under Diagnosis
;
$sqlQuestion[68] =Write a query that lists all consultations seen in August 2007 who had entries of URTI under Diagnosis and those seen in August 2006 who also had similar entries under Diagnosis
;
$sqlQuestion[69] =Write a query that lists all consultations seen in August 2006 who had entries of URTI under Diagnosis and those seen in August 2015 who also had similar entries under Diagnosis
;
$sqlQuestion[70] =Write a query that selects all those seen 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 August 2006
;
$sqlQuestion[71] =Write a query that selects all those seen 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 August 2007
;
$sqlQuestion[72] =Write a query that selects all those seen 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 August 2008
;
$sqlQuestion[73] =Write a query that selects all those seen 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 August 2009
;
$sqlQuestion[74] =Write a query that selects all those seen 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 August 2010
;
$sqlQuestion[75] =Write a query that selects all those seen 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 August 2011
;
$sqlQuestion[76] =Write a query that selects all those seen 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 August 2012
;
$sqlQuestion[77] =Write a query that selects all those seen 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 August 2013
;
$sqlQuestion[78] =Write a query that selects all those seen 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 August 2014
;
$sqlQuestion[79] =Write a query that selects all those seen 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 August 2015
;
$sqlQuestion[80] =Write a query that lists the last 20 appointments in August 2006
;
$sqlQuestion[81] =Write a query that lists the last 20 appointments in August 2007
;
$sqlQuestion[82] =Write a query that lists the last 20 appointments in August 2008
;
$sqlQuestion[83] =Write a query that lists the last 20 appointments in August 2009
;
$sqlQuestion[84] =Write a query that lists the last 20 appointments in August 2010
;
$sqlQuestion[85] =Write a query that lists the last 20 appointments in August 2011
;
$sqlQuestion[86] =Write a query that lists the last 20 appointments in August 2012
;
$sqlQuestion[87] =Write a query that lists the last 20 appointments in August 2013
;
$sqlQuestion[88] =Write a query that lists the last 20 appointments in August 2014
;
$sqlQuestion[89] =Write a query that lists the last 20 appointments in August 2015
;
$sqlQuestion[90] =Write a query that lists all the patients seen in August 2006 and August 2007
;
$sqlQuestion[91] =Write a query that lists all the patients seen in August 2007 and August 2008
;
$sqlQuestion[92] =Write a query that lists all the patients seen in August 2008 and August 2009
;
$sqlQuestion[93] =Write a query that lists all the patients seen in August 2009 and August 2010
;
$sqlQuestion[94] =Write a query that lists all the patients seen in August 2010 and August 2011
;
$sqlQuestion[95] =Write a query that lists all the patients seen in August 2011 and August 2012
;
$sqlQuestion[96] =Write a query that lists all the patients seen in August 2012 and August 2013
;
$sqlQuestion[97] =Write a query that lists all the patients seen in August 2013 and August 2014
;
$sqlQuestion[98] =Write a query that lists all the patients seen in August 2014 and August 2015
;
$sqlQuestion[99] =Write a query that lists all the patients seen in August 2015 and August 2006
;
$sqlQuestion[100] =Write a query to list all those referred in August 2006
;
$sqlQuestion[101] =Write a query to list all those referred in August 2007
;
$sqlQuestion[102] =Write a query to list all those referred in August 2008
;
$sqlQuestion[103] =Write a query to list all those referred in August 2009
;
$sqlQuestion[104] =Write a query to list all those referred in August 2010
;
$sqlQuestion[105] =Write a query to list all those referred in August 2011
;
$sqlQuestion[106] =Write a query to list all those referred in August 2012
;
$sqlQuestion[107] =Write a query to list all those referred in August 2013
;
$sqlQuestion[108] =Write a query to list all those referred in August 2014
;
$sqlQuestion[109] =Write a query to list all those referred in August 2015
;
$sqlQuestion[110] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2006
;
$sqlQuestion[111] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2007
;
$sqlQuestion[112] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2008
;
$sqlQuestion[113] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2009
;
$sqlQuestion[114] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2010
;
$sqlQuestion[115] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2011
;
$sqlQuestion[116] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2012
;
$sqlQuestion[117] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2013
;
$sqlQuestion[118] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2014
;
$sqlQuestion[119] =Write a query that lists appointments before 1050 hours and after 1730 hours in August 2015
;
$sqlQuestion[120] =Write a query that lists those seen in August 2006 who have similar complaints as those seen in August 2007
;
$sqlQuestion[121] =Write a query that lists those seen in August 2007 who have similar complaints as those seen in August 2008
;
$sqlQuestion[122] =Write a query that lists those seen in August 2008 who have similar complaints as those seen in August 2009
;
$sqlQuestion[123] =Write a query that lists those seen in August 2009 who have similar complaints as those seen in August 2010
;
$sqlQuestion[124] =Write a query that lists those seen in August 2010 who have similar complaints as those seen in August 2011
;
$sqlQuestion[125] =Write a query that lists those seen in August 2011 who have similar complaints as those seen in August 2012
;
$sqlQuestion[126] =Write a query that lists those seen in August 2012 who have similar complaints as those seen in August 2013
;
$sqlQuestion[127] =Write a query that lists those seen in August 2013 who have similar complaints as those seen in August 2014
;
$sqlQuestion[128] =Write a query that lists those seen in August 2014 who have similar complaints as those seen in August 2015
;
$sqlQuestion[129] =Write a query that lists those seen in August 2015 who have similar complaints as those seen in August 2006
;
$sqlQuestion[130] =Write a query that lists all consultations in the first week of August 2006
;
$sqlQuestion[131] =Write a query that lists all consultations in the first week of August 2007
;
$sqlQuestion[132] =Write a query that lists all consultations in the first week of August 2008
;
$sqlQuestion[133] =Write a query that lists all consultations in the first week of August 2009
;
$sqlQuestion[134] =Write a query that lists all consultations in the first week of August 2010
;
$sqlQuestion[135] =Write a query that lists all consultations in the first week of August 2011
;
$sqlQuestion[136] =Write a query that lists all consultations in the first week of August 2012
;
$sqlQuestion[137] =Write a query that lists all consultations in the first week of August 2013
;
$sqlQuestion[138] =Write a query that lists all consultations in the first week of August 2014
;
$sqlQuestion[139] =Write a query that lists all consultations in the first week of August 2015
;
$sqlQuestion[140] =Write a query that lists all consultations in the second week of August 2006
;
$sqlQuestion[141] =Write a query that lists all consultations in the second week of August 2007
;
$sqlQuestion[142] =Write a query that lists all consultations in the second week of August 2008
;
$sqlQuestion[143] =Write a query that lists all consultations in the second week of August 2009
;
$sqlQuestion[144] =Write a query that lists all consultations in the second week of August 2010
;
$sqlQuestion[145] =Write a query that lists all consultations in the second week of August 2011
;
$sqlQuestion[146] =Write a query that lists all consultations in the second week of August 2012
;
$sqlQuestion[147] =Write a query that lists all consultations in the second week of August 2013
;
$sqlQuestion[148] =Write a query that lists all consultations in the second week of August 2014
;
$sqlQuestion[149] =Write a query that lists all consultations in the second week of August 2015
;
$sqlQuestion[150] =Write a query that lists all consultations in the third week of August 2006
;
$sqlQuestion[151] =Write a query that lists all consultations in the third week of August 2007
;
$sqlQuestion[152] =Write a query that lists all consultations in the third week of August 2008
;
$sqlQuestion[153] =Write a query that lists all consultations in the third week of August 2009
;
$sqlQuestion[154] =Write a query that lists all consultations in the third week of August 2010
;
$sqlQuestion[155] =Write a query that lists all consultations in the third week of August 2011
;
$sqlQuestion[156] =Write a query that lists all consultations in the third week of August 2012
;
$sqlQuestion[157] =Write a query that lists all consultations in the third week of August 2013
;
$sqlQuestion[158] =Write a query that lists all consultations in the third week of August 2014
;
$sqlQuestion[159] =Write a query that lists all consultations in the third week of August 2015
;
$sqlQuestion[160] =Write a query that lists all consultations from the 22nd to the end of August 2006
;
$sqlQuestion[161] =Write a query that lists all consultations from the 22nd to the end of August 2007
;
$sqlQuestion[162] =Write a query that lists all consultations from the 22nd to the end of August 2008
;
$sqlQuestion[163] =Write a query that lists all consultations from the 22nd to the end of August 2009
;
$sqlQuestion[164] =Write a query that lists all consultations from the 22nd to the end of August 2010
;
$sqlQuestion[165] =Write a query that lists all consultations from the 22nd to the end of August 2011
;
$sqlQuestion[166] =Write a query that lists all consultations from the 22nd to the end of August 2012
;
$sqlQuestion[167] =Write a query that lists all consultations from the 22nd to the end of August 2013
;
$sqlQuestion[168] =Write a query that lists all consultations from the 22nd to the end of August 2014
;
$sqlQuestion[169] =Write a query that lists all consultations from the 22nd to the end of August 2015
;
$sqlQuestion[170] =Write a query that lists all consultations in August 2006 who have similar entries under treatments as the consultations seen in August 2007. Both years consultations must have entries under Notes
;
$sqlQuestion[171] =Write a query that lists all consultations in August 2007 who have similar entries under treatments as the consultations seen in August 2008. Both years consultations must have entries under Notes
;
$sqlQuestion[172] =Write a query that lists all consultations in August 2008 who have similar entries under treatments as the consultations seen in August 2009. Both years consultations must have entries under Notes
;
$sqlQuestion[173] =Write a query that lists all consultations in August 2009 who have similar entries under treatments as the consultations seen in August 2010. Both years consultations must have entries under Notes
;
$sqlQuestion[174] =Write a query that lists all consultations in August 2010 who have similar entries under treatments as the consultations seen in August 2011. Both years consultations must have entries under Notes
;
$sqlQuestion[175] =Write a query that lists all consultations in August 2011 who have similar entries under treatments as the consultations seen in August 2012. Both years consultations must have entries under Notes
;
$sqlQuestion[176] =Write a query that lists all consultations in August 2012 who have similar entries under treatments as the consultations seen in August 2013. Both years consultations must have entries under Notes
;
$sqlQuestion[177] =Write a query that lists all consultations in August 2013 who have similar entries under treatments as the consultations seen in August 2014. Both years consultations must have entries under Notes
;
$sqlQuestion[178] =Write a query that lists all consultations in August 2014 who have similar entries under treatments as the consultations seen in August 2015. Both years consultations must have entries under Notes
;
$sqlQuestion[179] =Write a query that lists all consultations in August 2015 who have similar entries under treatments as the consultations seen in August 2006. Both years consultations must have entries under Notes
;
$sqlQuestion[180] =Write a query that lists all consultations seen in August 2006 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2007
;
$sqlQuestion[181] =Write a query that lists all consultations seen in August 2007 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2008
;
$sqlQuestion[182] =Write a query that lists all consultations seen in August 2008 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2009
;
$sqlQuestion[183] =Write a query that lists all consultations seen in August 2009 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2010
;
$sqlQuestion[184] =Write a query that lists all consultations seen in August 2010 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2011
;
$sqlQuestion[185] =Write a query that lists all consultations seen in August 2011 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2012
;
$sqlQuestion[186] =Write a query that lists all consultations seen in August 2012 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2013
;
$sqlQuestion[187] =Write a query that lists all consultations seen in August 2013 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2014
;
$sqlQuestion[188] =Write a query that lists all consultations seen in August 2014 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2015
;
$sqlQuestion[189] =Write a query that lists all consultations seen in August 2015 who have similarly entered notes, similarly entered treatments or similarly entered date of births in August 2006
;
$sqlQuestion[190] =Write a query that lists all consultations seen in August 2006 who have similarly entered complaints and similarly entered treatments in both months, in August 2006 and August 2007, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[191] =Write a query that lists all consultations seen in August 2007 who have similarly entered complaints and similarly entered treatments in both months, in August 2007 and August 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[192] =Write a query that lists all consultations seen in August 2008 who have similarly entered complaints and similarly entered treatments in both months, in August 2008 and August 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[193] =Write a query that lists all consultations seen in August 2009 who have similarly entered complaints and similarly entered treatments in both months, in August 2009 and August 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[194] =Write a query that lists all consultations seen in August 2010 who have similarly entered complaints and similarly entered treatments in both months, in August 2010 and August 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[195] =Write a query that lists all consultations seen in August 2011 who have similarly entered complaints and similarly entered treatments in both months, in August 2011 and August 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[196] =Write a query that lists all consultations seen in August 2012 who have similarly entered complaints and similarly entered treatments in both months, in August 2012 and August 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[197] =Write a query that lists all consultations seen in August 2013 who have similarly entered complaints and similarly entered treatments in both months, in August 2013 and August 2014, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[198] =Write a query that lists all consultations seen in August 2014 who have similarly entered complaints and similarly entered treatments in both months, in August 2014 and August 2015, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[199] =Write a query that lists all consultations seen in August 2015 who have similarly entered complaints and similarly entered treatments in both months, in August 2015 and August 2006, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[200] =Write a query that lists all consultations seen in August 2015 who had similarly entered complaints and similarly entered treatments in both months August 2015 and August 2014, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[201] =Write a query that lists all consultations seen in August 2014 who had similarly entered complaints and similarly entered treatments in both months August 2014 and August 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[202] =Write a query that lists all consultations seen in August 2013 who had similarly entered complaints and similarly entered treatments in both months August 2013 and August 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[203] =Write a query that lists all consultations seen in August 2012 who had similarly entered complaints and similarly entered treatments in both months August 2012 and August 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[204] =Write a query that lists all consultations seen in August 2011 who had similarly entered complaints and similarly entered treatments in both months August 2011 and August 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[205] =Write a query that lists all consultations seen in August 2010 who had similarly entered complaints and similarly entered treatments in both months August 2010 and August 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[206] =Write a query that lists all consultations seen in August 2009 who had similarly entered complaints and similarly entered treatments in both months August 2009 and August 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[207] =Write a query that lists all consultations seen in August 2008 who had similarly entered complaints and similarly entered treatments in both months August 2008 and August 2007, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[208] =Write a query that lists all consultations seen in August 2007 who had similarly entered complaints and similarly entered treatments in both months August 2007 and August 2006, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[209] =Write a query that lists all consultations seen in August 2006 who had similarly entered complaints and similarly entered treatments in both months August 2006 and August 2015, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlQuestion[210] =Write a query that lists all consultations seen in August 2015 who had similar complaints entries as those seen in August 2014, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[211] =Write a query that lists all consultations seen in August 2014 who had similar complaints entries as those seen in August 2013, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[212] =Write a query that lists all consultations seen in August 2013 who had similar complaints entries as those seen in August 2012, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[213] =Write a query that lists all consultations seen in August 2012 who had similar complaints entries as those seen in August 2011, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[214] =Write a query that lists all consultations seen in August 2011 who had similar complaints entries as those seen in August 2010, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[215] =Write a query that lists all consultations seen in August 2010 who had similar complaints entries as those seen in August 2009, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[216] =Write a query that lists all consultations seen in August 2009 who had similar complaints entries as those seen in August 2008, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[217] =Write a query that lists all consultations seen in August 2008 who had similar complaints entries as those seen in August 2007, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[218] =Write a query that lists all consultations seen in August 2007 who had similar complaints entries as those seen in August 2006, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[219] =Write a query that lists all consultations seen in August 2006 who had similar complaints entries as those seen in August 2015, each of them in both months having consultation time of more than 10 minutes
;
$sqlQuestion[220] =Write a query that lists all consultations seen in August 2015 who had similarly entered diagnosis as those seen in August 2014
;
$sqlQuestion[221] =Write a query that lists all consultations seen in August 2014 who had similarly entered diagnosis as those seen in August 2013
;
$sqlQuestion[222] =Write a query that lists all consultations seen in August 2013 who had similarly entered diagnosis as those seen in August 2012
;
$sqlQuestion[223] =Write a query that lists all consultations seen in August 2012 who had similarly entered diagnosis as those seen in August 2011
;
$sqlQuestion[224] =Write a query that lists all consultations seen in August 2011 who had similarly entered diagnosis as those seen in August 2010
;
$sqlQuestion[225] =Write a query that lists all consultations seen in August 2010 who had similarly entered diagnosis as those seen in August 2009
;
$sqlQuestion[226] =Write a query that lists all consultations seen in August 2009 who had similarly entered diagnosis as those seen in August 2008
;
$sqlQuestion[227] =Write a query that lists all consultations seen in August 2008 who had similarly entered diagnosis as those seen in August 2007
;
$sqlQuestion[228] =Write a query that lists all consultations seen in August 2007 who had similarly entered diagnosis as those seen in August 2006
;
$sqlQuestion[229] =Write a query that lists all consultations seen in August 2006 who had similarly entered diagnosis as those seen in August 2015
;
$sqlQuestion[230] =Write a query that selects all those seen 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 August 2006 and for those with similar diagnosis in August 2007
;
$sqlQuestion[231] =Write a query that selects all those seen 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 August 2007 and for those with similar diagnosis in August 2008
;
$sqlQuestion[232] =Write a query that selects all those seen 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 August 2008 and for those with similar diagnosis in August 2009
;
$sqlQuestion[233] =Write a query that selects all those seen 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 August 2009 and for those with similar diagnosis in August 2010
;
$sqlQuestion[234] =Write a query that selects all those seen 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 August 2010 and for those with similar diagnosis in August 2011
;
$sqlQuestion[235] =Write a query that selects all those seen 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 August 2011 and for those with similar diagnosis in August 2012
;
$sqlQuestion[236] =Write a query that selects all those seen 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 August 2012 and for those with similar diagnosis in August 2013
;
$sqlQuestion[237] =Write a query that selects all those seen 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 August 2013 and for those with similar diagnosis in August 2014
;
$sqlQuestion[238] =Write a query that selects all those seen 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 August 2014 and for those with similar diagnosis in August 2015
;
$sqlQuestion[239] =Write a query that selects all those seen 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 August 2015 and for those with similar diagnosis in August 2006
;
$sqlQuestion[240] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2006
;
$sqlQuestion[241] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2007
;
$sqlQuestion[242] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2008
;
$sqlQuestion[243] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2009
;
$sqlQuestion[244] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2010
;
$sqlQuestion[245] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2011
;
$sqlQuestion[246] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2012
;
$sqlQuestion[247] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2013
;
$sqlQuestion[248] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2014
;
$sqlQuestion[249] =Write a query that selects all those seen with entry under diagnosis using JOIN. The results are to be ordered by diagnosis in ascending order. These are for those seen in August 2015
;
$sqlQuestion[250] =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 August 2006
;
$sqlQuestion[251] =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 August 2007
;
$sqlQuestion[252] =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 August 2008
;
$sqlQuestion[253] =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 August 2009
;
$sqlQuestion[254] =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 August 2010
;
$sqlQuestion[255] =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 August 2011
;
$sqlQuestion[256] =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 August 2012
;
$sqlQuestion[257] =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 August 2013
;
$sqlQuestion[258] =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 August 2014
;
$sqlQuestion[259] =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 August 2015
;
$sqlQuestion[260] =Write a query that lists the last seen 50 appointments in August 2006
;
$sqlQuestion[261] =Write a query that lists the last seen 50 appointments in August 2007
;
$sqlQuestion[262] =Write a query that lists the last seen 50 appointments in August 2008
;
$sqlQuestion[263] =Write a query that lists the last seen 50 appointments in August 2009
;
$sqlQuestion[264] =Write a query that lists the last seen 50 appointments in August 2010
;
$sqlQuestion[265] =Write a query that lists the last seen 50 appointments in August 2011
;
$sqlQuestion[266] =Write a query that lists the last seen 50 appointments in August 2012
;
$sqlQuestion[267] =Write a query that lists the last seen 50 appointments in August 2013
;
$sqlQuestion[268] =Write a query that lists the last seen 50 appointments in August 2014
;
$sqlQuestion[269] =Write a query that lists the last seen 50 appointments in August 2015
;
if ($_POST[‘make’] = $m){
$i = $m;
}
}
//DECLARING $sqlResult & $query ARRAYS
$sqlResult = array();
$query = array();
$n = $i;
//SETTING OUT & USING FOR LOOP TO KNOW EXACTLY WHAT IS IN THE $sqlResult ARRAY & PICKING THE APPROPRIATE ONE
for ($m = 0; $m <= $n; $m++){
//August $sqlResult:
$sqlResult[0] = Patients seen in August 2006 whose notes entries contain the letter ‘C’
;
$sqlResult[1] = Patients seen in August 2007 whose notes entries contain the letter ‘C’
;
$sqlResult[2] = Patients seen in August 2008 whose notes entries contain the letter ‘C’
;
$sqlResult[3] = Patients seen in August 2009 whose notes entries contain the letter ‘C’
;
$sqlResult[4] = Patients seen in August 2010 whose notes entries contain the letter ‘C’
;
$sqlResult[5] = Patients seen in August 2011 whose notes entries contain the letter ‘C’
;
$sqlResult[6] = Patients seen in August 2012 whose notes entries contain the letter ‘C’
;
$sqlResult[7] = Patients seen in August 2013 whose notes entries contain the letter ‘C’
;
$sqlResult[8] = Patients seen in August 2014 whose notes entries contain the letter ‘C’
;
$sqlResult[9] = Patients seen in August 2015 whose notes entries contain the letter ‘C’
;
$sqlResult[10] = Patients seen in August 2006 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2007
;
$sqlResult[11] = Patients seen in August 2007 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2008
;
$sqlResult[12] = Patients seen in August 2008 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2009
;
$sqlResult[13] = Patients seen in August 2009 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2010
;
$sqlResult[14] = Patients seen in August 2010 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2011
;
$sqlResult[15] = Patients seen in August 2011 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2012
;
$sqlResult[16] = Patients seen in August 2012 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2013
;
$sqlResult[17] = Patients seen in August 2013 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2014
;
$sqlResult[18] = Patients seen in August 2014 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2015
;
$sqlResult[19] = Patients seen in August 2015 who had similarly entered notes, similarly entered treatments or similarly entered date of births in August 2006
;
$sqlResult[20] = Patients seen in August 2015 who had similarly entered diagnosis as those seen in August 2014
;
$sqlResult[21] = Patients seen in August 2014 who had similarly entered diagnosis as those seen in August 2013
;
$sqlResult[22] = Patients seen in August 2013 who had similarly entered diagnosis as those seen in August 2012
;
$sqlResult[23] = Patients seen in August 2012 who had similarly entered diagnosis as those seen in August 2011
;
$sqlResult[24] = Patients seen in August 2011 who had similarly entered diagnosis as those seen in August 2010
;
$sqlResult[25] = Patients seen in August 2010 who had similarly entered diagnosis as those seen in August 2009
;
$sqlResult[26] = Patients seen in August 2009 who had similarly entered diagnosis as those seen in August 2008
;
$sqlResult[27] = Patients seen in August 2008 who had similarly entered diagnosis as those seen in August 2007
;
$sqlResult[28] = Patients seen in August 2007 who had similarly entered diagnosis as those seen in August 2006
;
$sqlResult[29] = Patients seen in August 2006 who had similarly entered diagnosis as those seen in August 2015
;
$sqlResult[30] = Patients seen in August 2015 who had similarly entered complaints and similarly entered treatments in both months, August 2015 and August 2014, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[31] = Patients seen in August 2014 who had similarly entered complaints and similarly entered treatments in both months, August 2014 and August 2013, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[32] = Patients seen in August 2013 who had similarly entered complaints and similarly entered treatments in both months, August 2013 and August 2012, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[33] = Patients seen in August 2012 who had similarly entered complaints and similarly entered treatments in both months, August 2012 and August 2011, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[34] = Patients seen in August 2011 who had similarly entered complaints and similarly entered treatments in both months, August 2011 and August 2010, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[35] = Patients seen in August 2010 who had similarly entered complaints and similarly entered treatments in both months, August 2010 and August 2009, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[36] = Patients seen in August 2009 who had similarly entered complaints and similarly entered treatments in both months, August 2009 and August 2008, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[37] = Patients seen in August 2008 who had similarly entered complaints and similarly entered treatments in both months, August 2008 and August 2007, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[38] = Patients seen in August 2007 who had similarly entered complaints and similarly entered treatments in both months, August 2007 and August 2006, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[39] = Patients seen in August 2006 who had similarly entered complaints and similarly entered treatments in both months, August 2006 and August 2015, but the notes entries in both months are not similar, and there are entries under complaints, treatments, notes and diagnosis in both months
;
$sqlResult[40] = Patients seen in August 2015 who had similarly complaints entries as those seen in August 2014, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[41] = Patients seen in August 2014 who had similarly complaints entries as those seen in August 2013, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[42] = Patients seen in August 2013 who had similarly complaints entries as those seen in August 2012, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[43] = Patients seen in August 2012 who had similarly complaints entries as those seen in August 2011, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[44] = Patients seen in August 2011 who had similarly complaints entries as those seen in August 2010, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[45] = Patients seen in August 2010 who had similarly complaints entries as those seen in August 2009, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[46] = Patients seen in August 2009 who had similarly complaints entries as those seen in August 2008, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[47] = Patients seen in August 2008 who had similarly complaints entries as those seen in August 2007, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[48] = Patients seen in August 2007 who had similarly complaints entries as those seen in August 2006, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[49] = Patients seen in August 2006 who had similarly complaints entries as those seen in August 2015, each of them in both months having consultation time of more than 10 minutes
;
$sqlResult[50] =Patients seen in August 2015 and August 2014
;
$sqlResult[51] =Patients seen in August 2014 and August 2013
;
$sqlResult[52] =Patients seen in August 2013 and August 2012
;
$sqlResult[53] =Patients seen in August 2012 and August 2011
;
$sqlResult[54] =Patients seen in August 2011 and August 2010
;