<p>Welcome to the SQL lab where you'll be working with the <code class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono" data-prestyled="true">hospital.sqlite</code> database. Your challenge is to dive deep into real-world SQL problems and come up with solutions using the database tables provided.</p>
<ul>
<li><strong>Table Used</strong>: <code class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono" data-prestyled="true">patients</code></li>
</ul>
<h2>Challenge:</h2>
<p>Show the total amount of male patients and the total amount of female patients in the <code class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono" data-prestyled="true">patients</code> table. Your goal is to display the two results in the same row.</p>
<h2>Concepts:</h2>
<ul>
<li><strong>SELECT</strong>: The SELECT statement is used to select data from a database.</li>
<li><strong>COUNT</strong>: This SQL aggregate function retrieves the number of entries that match a specific condition.</li>
<li><strong>WHERE</strong>: Used in SQL to filter records based on specific conditions.</li>
</ul>
<p>Good luck, and happy coding!</p>

Count Male and Female Patients in a Single Row

Challenge:

Concepts: