Combat-Fighter-Aircraft

I have created SQL Analysis project on Combat Fighter Aircraft and Data for aircraft fighter jet collected from ChatGPT. My Database have 28 metadata for detailed evaluation of fighter jets. This evaluation is for educational purpose and strictly based on the information I got for combat fighter aircraft from ChatGPT. In order to fetch result you have to upload excel csv same database in SQL workbench with table name fightjet.

Meta data for Combat Fighter Aircraft database

Aircraft Type , Name of Jet , Manufacturer of Jet , Year of Manufacture , Max Speed , Range in Miles , Max Altitude , Weapons , Crew Size , Cost , Country of Origin , Engine Type , Length(ft) , Wingspan , Combat Range , Service Ceiling , Introduced , Radar Type , Radar Range , Stealth Technology , Ejection System , Avionics System , Armament , Maximum G Force , Fuel Capacity , Battles Won , Fuel Type , Generation.

Type of Evaluation

first query for showing database. First 25 query are simple level. High level complex query are provided after 26 to 78.

1. The 2nd query is for evaluating maximum and minimum speed as well as altitute for each country and number of jets each country have.
2. The 3rd query is for evaluating how many jets are of which generation and their speed evaluation.
3. The 4th query is for finding out maximum altitute combat fighterjet belong to which country.
4. The 5th query shows that how many type of Radar type equipped in jets i have taken.
5. The 6th query shows that Maximum and Average fuel capacity fighter jet per country.
6. The 7th query shows that How many jets are equipped with which engine type and cost evaluation.
7. The 8th query show top wingspan jet.
8. The 9th query shows that when first and last jet introduced and jets introduced within that timeline.
9. The 10th query shows that Which generation jet have Max combat range.
10. The 11th query shows that most battle won fighterjet.
11. The 12th query shows that how many jets have which type of Ejection system.
12. The 13th query shows how many different generation fighterjet each country have.
13. The 14th query explain Radar type and Average and Max service ceiling.
14. 15th query show which jet can use all 3 weapon bombs, guns and missiles
15. 16th query shows how many jets are equipped with different type of Avionics system
16. 17th query for top combat range jet.
17. 18th query for how many jets have which type of Fuel.
18. 19th for top jet evaluation.
19. 20th query for how many jets have stealth technology.
20. 21th query to findout max G Force fighter jet.
21. 22nd query for sorting out countrywise number of jet with different engine type.
22. 23rd query for sorting out countrywise number of jet with different radar type.
23. 24th for yearwise cost evaluation per jet.
24. 25th for avionics sytem of jets per country.

    Hard and coplex level query

25. 26th query will provide generation , engine type , radar type, speed, altitute and cost evaluation in single go.
26. 27th query for top performance jet.
27. 28th query for top overall performance jet.
28. 29th Case complex query for performance evaluation of all jet with country and generation.
29. 30th Case query for Weighted performance score.
30. 31th Case query for Combat rank evaluation.
31. 32th Case query for Cost rant evaluation for engine type of jet.
32. 33th query for which radar type jet have which weapon rank.
33. 34th Speed Rank evaluation for each country.
34. 35th for Which generation fighterjet have which altitute rank.
35. 36th for which Fuel type in jets and their fuel capacity rank
36. 37th for battlewon rank evaluation per year.
37. 38th for jets having and not having stealth technology and their effect on altitute.
38. 39th for Finding out which Avionics system have which Battle won Rank.
39. 40th Altitute rank evaluation.
40. 41th Avionics system and generation wise Battle won rank.
41. 42th engine type , radar type and cost rank evaluation.
42. 43th performance rank evaluation countrywise.
43. 44th Fighter Composite Score evaluation.
44. 45th Fighter Weighted Performance evaluation.
45. 46th Fighter Generation Radar Analysis.
46. 47th Fighter Country Avionics Analysis.
47. 48th Fighter Engine Radar Analysis.
48. 49th Advanced Fighter Analysis.
49. 50th Fighter Fuel Avionics Analysis.
50. 51th Fighter Engine Avionics Radar Analysis.
51. 52th Fighter Engine Radar performance level Analysis.
52. 53th Max Battles Won Per Country with which jet.
53. 54th Max and Min Battles Won Per Country with jets.
54. 55th Max Battle Won analysis.
55. 56th Rank Within Country by analysing Weighted Score Per Jet.
56. 57th Rank Within Country by analysing Efficiency Ratio Per Jet.
57. 58th Battles Won Trend Per Jet analysis.
58. 59th Time Series Analysis.
59. 60th Time Series Forecasting.
60. 61th Percentile Rank Analysis.
61. 62th Market Share Analysis.
62. 63th Sensitivity Analysis.
63. 64th Sentiment Analysis.
64. 65th Network Analysis.
65. 66th Trend Analysis.
66. 67th Time Series Analysis for F-22 Raptor
67. 68th Manufacturer of Jets vs Market Share Analysis.
68. 69th Radar Technology Analysis
69. 70th Efficiency Ratio and Efficiency Rank analysis generationwise
70. 71th Diplomatic Analysis by comparing jet with other countries
71. 72th Competitiveness Rank 1 analysis.
72. 73th Advance fighterjet of each generation.
73. 74th Maintenance Cost Analysis.
74. 75th Combat Range Analysis (USA topped)
75. 76th Technology Advancement Analysis (Radar-India), (StealthTech-Russia)
76. 78th Overall Performance Rank within country #END