My First SQL Project: Crop Production Analysis

📌Introduction Hi everyone! 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. 📊 About the Dataset I created a database called green_harvest and a table named crop_production. The table includes details like: crop name state season production rainfall land used (hectares) 🧠 What I Did Using SQL Created Database create database green_harvest ; use green_harvest ; Created Table create table crop_production ( crop_id int , crop_name varchar ( 50 ), state varchar ( 50 ), season varchar ( 20 ), year int , hectares decimal ( 10 , 2 ), production decimal ( 10 , 2 ), rainfall decimal ( 10 , 2 ) ); SQL execution in MySQL Workbench: Inserted Sample Data insert into crop_production values ( 1 , 'Rice' , 'Telangana' , 'Kharif' , 2023 , 1500 , 4000 , 900 ), ( 2 , 'Wheat' , 'Punjab' , 'Rabi' , 2023 , 2000 , 5500 , 650 ), ( 3 , 'Maize' , 'Karnataka' , 'Kharif