<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Seelam Anusha</title>
    <description>The latest articles on DEV Community by Seelam Anusha (@anusha_seelam_17e1c00959f).</description>
    <link>https://dev.to/anusha_seelam_17e1c00959f</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3828551%2F8078d93b-cb79-423b-9b64-8015a1fd9359.png</url>
      <title>DEV Community: Seelam Anusha</title>
      <link>https://dev.to/anusha_seelam_17e1c00959f</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/anusha_seelam_17e1c00959f"/>
    <language>en</language>
    <item>
      <title>Road Relic Rental – Car Rental &amp; Leasing Web Application</title>
      <dc:creator>Seelam Anusha</dc:creator>
      <pubDate>Mon, 18 May 2026 10:21:33 +0000</pubDate>
      <link>https://dev.to/anusha_seelam_17e1c00959f/road-relic-rental-car-rental-leasing-web-application-4em1</link>
      <guid>https://dev.to/anusha_seelam_17e1c00959f/road-relic-rental-car-rental-leasing-web-application-4em1</guid>
      <description>&lt;h1&gt;
  
  
  Road Relic Rental 🚗
&lt;/h1&gt;

&lt;h2&gt;
  
  
  Introduction
&lt;/h2&gt;

&lt;p&gt;Road Relic Rental is a frontend car rental and leasing website developed using HTML, CSS, Bootstrap, and JavaScript.&lt;/p&gt;

&lt;p&gt;The project is designed with a modern and responsive user interface that allows users to explore cars, view rental details, and experience a simulated booking system easily.&lt;/p&gt;




&lt;h2&gt;
  
  
  Technologies Used
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;HTML5&lt;/li&gt;
&lt;li&gt;CSS3&lt;/li&gt;
&lt;li&gt;Bootstrap 5&lt;/li&gt;
&lt;li&gt;JavaScript&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Tags
&lt;/h3&gt;

&lt;h1&gt;
  
  
  webdev #javascript #bootstrap #html #css #frontend #projects
&lt;/h1&gt;




&lt;h2&gt;
  
  
  Features
&lt;/h2&gt;

&lt;h3&gt;
  
  
  🚘 Car Rental Interface
&lt;/h3&gt;

&lt;p&gt;Users can:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Browse different cars&lt;/li&gt;
&lt;li&gt;View car specifications&lt;/li&gt;
&lt;li&gt;Check rental pricing&lt;/li&gt;
&lt;li&gt;Explore leasing options&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  📱 Responsive Design
&lt;/h3&gt;

&lt;p&gt;The website is fully responsive and optimized for:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Mobile devices&lt;/li&gt;
&lt;li&gt;Tablets&lt;/li&gt;
&lt;li&gt;Desktop systems&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  🎨 Modern UI Design
&lt;/h3&gt;

&lt;p&gt;Implemented components include:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Bootstrap navigation bar&lt;/li&gt;
&lt;li&gt;Carousel/slideshow&lt;/li&gt;
&lt;li&gt;Booking forms&lt;/li&gt;
&lt;li&gt;Cards and buttons&lt;/li&gt;
&lt;li&gt;Interactive layouts&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  🔐 Authentication Simulation
&lt;/h3&gt;

&lt;p&gt;Added:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Face authentication simulation&lt;/li&gt;
&lt;li&gt;Fingerprint verification simulation&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  ⭐ Review &amp;amp; Rating System
&lt;/h3&gt;

&lt;p&gt;Users can:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Give ratings&lt;/li&gt;
&lt;li&gt;Submit reviews and feedback&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  📍 GPS Tracking Simulation
&lt;/h3&gt;

&lt;p&gt;Integrated a GPS tracking concept for improving the user experience in rental management.&lt;/p&gt;




&lt;h2&gt;
  
  
  Cars Included
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Honda Civic&lt;/li&gt;
&lt;li&gt;Lexus ES 300h&lt;/li&gt;
&lt;li&gt;Toyota RAV4&lt;/li&gt;
&lt;li&gt;Toyota Fortuner&lt;/li&gt;
&lt;li&gt;Audi A4&lt;/li&gt;
&lt;li&gt;Ford Models&lt;/li&gt;
&lt;/ul&gt;




&lt;h2&gt;
  
  
  Learning Outcome
&lt;/h2&gt;

&lt;p&gt;This project helped me improve my understanding of:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Frontend development&lt;/li&gt;
&lt;li&gt;Responsive web design&lt;/li&gt;
&lt;li&gt;Bootstrap components&lt;/li&gt;
&lt;li&gt;JavaScript DOM manipulation&lt;/li&gt;
&lt;li&gt;UI/UX design concepts&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;It also helped me gain practical experience in building real-world styled web applications.&lt;/p&gt;




&lt;h2&gt;
  
  
  GitHub Repository
&lt;/h2&gt;

&lt;p&gt;GitHub Link:&lt;br&gt;
&lt;a href="https://github.com/anusha-seelam/Road-Relic-Rental" rel="noopener noreferrer"&gt;https://github.com/anusha-seelam/Road-Relic-Rental&lt;/a&gt;&lt;/p&gt;




&lt;h2&gt;
  
  
  Project Screenshots
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fo1ix9lmg4tv6nm2yz5j5.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fo1ix9lmg4tv6nm2yz5j5.png" alt="Homepage" width="800" height="426"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fdt3xgw83jsvmic8xauy3.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fdt3xgw83jsvmic8xauy3.png" alt="Working Page" width="800" height="405"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F06u297rbrotsqypnt805.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F06u297rbrotsqypnt805.png" alt="Booking Page" width="800" height="420"&gt;&lt;/a&gt;&lt;/p&gt;




&lt;h2&gt;
  
  
  Conclusion
&lt;/h2&gt;

&lt;p&gt;Road Relic Rental is a user-friendly frontend web application that demonstrates modern UI/UX concepts for car rental and leasing systems.&lt;/p&gt;

&lt;p&gt;This project was a great learning experience and helped me strengthen my frontend development skills.&lt;/p&gt;

&lt;p&gt;Thank you for reading 🚀&lt;/p&gt;

&lt;h2&gt;
  
  
  GitHub Repository
&lt;/h2&gt;

&lt;p&gt;🔗 GitHub Repository:&lt;br&gt;
&lt;a href="https://github.com/anusha-seelam/Road-Relic-Rental" rel="noopener noreferrer"&gt;https://github.com/anusha-seelam/Road-Relic-Rental&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Feedback and suggestions are always welcome 😊&lt;/p&gt;

</description>
      <category>frontend</category>
      <category>javascript</category>
      <category>showdev</category>
      <category>webdev</category>
    </item>
    <item>
      <title>Turning Hospital Data into Insights with Tableau</title>
      <dc:creator>Seelam Anusha</dc:creator>
      <pubDate>Mon, 23 Mar 2026 16:09:45 +0000</pubDate>
      <link>https://dev.to/anusha_seelam_17e1c00959f/turning-hospital-data-into-insights-with-tableau-blm</link>
      <guid>https://dev.to/anusha_seelam_17e1c00959f/turning-hospital-data-into-insights-with-tableau-blm</guid>
      <description>&lt;p&gt;📌 Introduction&lt;/p&gt;

&lt;p&gt;Hi everyone!&lt;/p&gt;

&lt;p&gt;In this Tableau project, I built a Hospital Performance Dashboard using Tableau to analyze healthcare data and uncover meaningful insights.&lt;/p&gt;

&lt;p&gt;📊 About the Dashboard&lt;/p&gt;

&lt;p&gt;This dashboard focuses on analyzing hospital data such as patient details, department performance, and revenue to better understand overall operations.&lt;/p&gt;

&lt;p&gt;🧠 Key Features of the Dashboard&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Department-wise revenue analysis
&lt;/li&gt;
&lt;li&gt;Patient count by department
&lt;/li&gt;
&lt;li&gt;Monthly patient trends
&lt;/li&gt;
&lt;li&gt;Insurance distribution
&lt;/li&gt;
&lt;li&gt;State-wise hospital locations
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;📈 Insights&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Cardiology and Neurology departments generate high revenue
&lt;/li&gt;
&lt;li&gt;Patient visits show variation across months
&lt;/li&gt;
&lt;li&gt;Majority of patients have insurance coverage
&lt;/li&gt;
&lt;li&gt;Different departments handle different patient volumes
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;📊 Dashboard Visualization&lt;/p&gt;

&lt;p&gt;You can explore the interactive dashboard here:&lt;br&gt;
&lt;a href="https://public.tableau.com/app/profile/anusha.seelam2683/viz/HospitalPerformanceDashboard_17625215617560/HospitalPerformanceDashboard?publish=yes" rel="noopener noreferrer"&gt;https://public.tableau.com/app/profile/anusha.seelam2683/viz/HospitalPerformanceDashboard_17625215617560/HospitalPerformanceDashboard?publish=yes&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F7bhd7w87ngg6vtjyh6mb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F7bhd7w87ngg6vtjyh6mb.png" alt="Hospital Performance Dashboard showing revenue, patient trends, and department analysis" width="800" height="425"&gt;&lt;/a&gt;&lt;/p&gt;

</description>
      <category>tableau</category>
      <category>datavisualization</category>
      <category>analytics</category>
      <category>learning</category>
    </item>
    <item>
      <title>My First SQL Project: Crop Production Analysis</title>
      <dc:creator>Seelam Anusha</dc:creator>
      <pubDate>Fri, 20 Mar 2026 08:44:11 +0000</pubDate>
      <link>https://dev.to/anusha_seelam_17e1c00959f/my-first-sql-project-crop-production-analysis-5455</link>
      <guid>https://dev.to/anusha_seelam_17e1c00959f/my-first-sql-project-crop-production-analysis-5455</guid>
      <description>&lt;p&gt;📌Introduction&lt;/p&gt;

&lt;p&gt;Hi everyone! &lt;/p&gt;

&lt;p&gt;This is my first SQL project where I worked on a small dataset related to crop production. I wanted to understand how production varies across states, seasons, and crops using simple SQL queries.&lt;/p&gt;

&lt;p&gt;📊 About the Dataset&lt;/p&gt;

&lt;p&gt;I created a database called green_harvest and a table named crop_production.&lt;/p&gt;

&lt;p&gt;The table includes details like:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;crop name&lt;/li&gt;
&lt;li&gt;state&lt;/li&gt;
&lt;li&gt;season&lt;/li&gt;
&lt;li&gt;production&lt;/li&gt;
&lt;li&gt;rainfall&lt;/li&gt;
&lt;li&gt;land used (hectares)&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;🧠 What I Did Using SQL&lt;/p&gt;

&lt;h2&gt;
  
  
  Created Database
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;create&lt;/span&gt; &lt;span class="k"&gt;database&lt;/span&gt; &lt;span class="n"&gt;green_harvest&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="n"&gt;use&lt;/span&gt; &lt;span class="n"&gt;green_harvest&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Created Table
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;create&lt;/span&gt; &lt;span class="k"&gt;table&lt;/span&gt; &lt;span class="n"&gt;crop_production&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;
    &lt;span class="n"&gt;crop_id&lt;/span&gt; &lt;span class="nb"&gt;int&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;crop_name&lt;/span&gt; &lt;span class="nb"&gt;varchar&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;50&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="k"&gt;state&lt;/span&gt; &lt;span class="nb"&gt;varchar&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;50&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="n"&gt;season&lt;/span&gt; &lt;span class="nb"&gt;varchar&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;20&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="nb"&gt;year&lt;/span&gt; &lt;span class="nb"&gt;int&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;hectares&lt;/span&gt; &lt;span class="nb"&gt;decimal&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;10&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="n"&gt;production&lt;/span&gt; &lt;span class="nb"&gt;decimal&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;10&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
    &lt;span class="n"&gt;rainfall&lt;/span&gt; &lt;span class="nb"&gt;decimal&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;10&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;);&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  SQL execution in MySQL Workbench:
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fa4017drg2d37332x3ci3.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fa4017drg2d37332x3ci3.png" alt="SQL queries executed in MySQL Workbench showing table creation" width="800" height="427"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Inserted Sample Data
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;insert&lt;/span&gt; &lt;span class="k"&gt;into&lt;/span&gt; &lt;span class="n"&gt;crop_production&lt;/span&gt; &lt;span class="k"&gt;values&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Rice'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Telangana'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Kharif'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2023&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;1500&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;4000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;900&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Wheat'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Punjab'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Rabi'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2023&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;5500&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;650&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Maize'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Karnataka'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Kharif'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2023&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;1200&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;3000&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;800&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;4&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Rice'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Andhra Pradesh'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Kharif'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2023&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;1800&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;4800&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;950&lt;/span&gt;&lt;span class="p"&gt;),&lt;/span&gt;
&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="mi"&gt;5&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Cotton'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Gujarat'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s1"&gt;'Kharif'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;2023&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;1400&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;3500&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;700&lt;/span&gt;&lt;span class="p"&gt;);&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Checked the Data
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;crop_production&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Sample output of the dataset:
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F7grb2m74zhn1els7av24.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F7grb2m74zhn1els7av24.png" alt="Output of crop_production table showing crop data" width="800" height="425"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;👉 This helped me see all the records clearly.&lt;/p&gt;

&lt;h2&gt;
  
  
  Total Production
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="k"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;production&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;total_production&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;crop_production&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;👉 I used this to calculate overall production.&lt;/p&gt;

&lt;h2&gt;
  
  
  Crop-wise Production
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="n"&gt;crop_name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;production&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;total_production&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;crop_production&lt;/span&gt; &lt;span class="k"&gt;group&lt;/span&gt; &lt;span class="k"&gt;by&lt;/span&gt; &lt;span class="n"&gt;crop_name&lt;/span&gt; &lt;span class="k"&gt;order&lt;/span&gt; &lt;span class="k"&gt;by&lt;/span&gt; &lt;span class="n"&gt;total_production&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;👉 This shows how each crop is performing.&lt;/p&gt;

&lt;h2&gt;
  
  
  Top Producing State
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="k"&gt;state&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;production&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;total_production&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;crop_production&lt;/span&gt; &lt;span class="k"&gt;group&lt;/span&gt; &lt;span class="k"&gt;by&lt;/span&gt; &lt;span class="k"&gt;state&lt;/span&gt; &lt;span class="k"&gt;order&lt;/span&gt; &lt;span class="k"&gt;by&lt;/span&gt; &lt;span class="n"&gt;total_production&lt;/span&gt; &lt;span class="k"&gt;desc&lt;/span&gt; &lt;span class="k"&gt;limit&lt;/span&gt; &lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;👉 This helped me find which state produces the most.&lt;/p&gt;

&lt;h2&gt;
  
  
  Average Rainfall by Season
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="n"&gt;season&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;avg&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;rainfall&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;crop_production&lt;/span&gt; &lt;span class="k"&gt;group&lt;/span&gt; &lt;span class="k"&gt;by&lt;/span&gt; &lt;span class="n"&gt;season&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;👉 I wanted to see how rainfall differs between seasons.&lt;/p&gt;

&lt;h2&gt;
  
  
  Land Usage vs Production
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;select&lt;/span&gt; &lt;span class="n"&gt;production&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="k"&gt;sum&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;hectares&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;total_hectares&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="n"&gt;crop_production&lt;/span&gt; &lt;span class="k"&gt;group&lt;/span&gt; &lt;span class="k"&gt;by&lt;/span&gt; &lt;span class="n"&gt;production&lt;/span&gt; &lt;span class="k"&gt;order&lt;/span&gt; &lt;span class="k"&gt;by&lt;/span&gt; &lt;span class="n"&gt;total_hectares&lt;/span&gt; &lt;span class="k"&gt;desc&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;👉 This shows how land usage relates to production.&lt;/p&gt;

&lt;p&gt;📈 What I Observed&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Rice production is higher compared to other crops&lt;/li&gt;
&lt;li&gt;Punjab has strong wheat production&lt;/li&gt;
&lt;li&gt;Kharif season gets more rainfall&lt;/li&gt;
&lt;li&gt;Production depends on both land and region&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;🛠️ Tools I Used&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;SQL&lt;/li&gt;
&lt;li&gt;MySQL&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;✅ Conclusion&lt;/p&gt;

&lt;p&gt;This project helped me understand how SQL can be used for basic data analysis. As a beginner, it gave me confidence in using queries like GROUP BY, SUM, and AVG.&lt;/p&gt;

&lt;p&gt;💬 Final Thoughts&lt;/p&gt;

&lt;p&gt;I'm still learning and improving my skills.&lt;br&gt;
If you have any suggestions or feedback, feel free to share&lt;/p&gt;

</description>
      <category>sql</category>
      <category>datascience</category>
      <category>beginners</category>
      <category>learning</category>
    </item>
  </channel>
</rss>
