Posts

Showing posts with the label SQL

SQL Case Study GEMINI VS CHATGPT

Image
                                                                                  GEMINI VS CHATGPT  SQL Challenge-GEMINI VS CHATGPT  TABLES Models Capabilities Benchmarks SQL SCHEMA    -- Table to store information about different models CREATE TABLE Models (     ModelID INT PRIMARY KEY,     ModelName VARCHAR(255) NOT NULL ); -- Table to store information about various capabilities CREATE TABLE Capabilities (     CapabilityID INT PRIMARY KEY,     CapabilityName VARCHAR(255) NOT NULL ); -- Table to store benchmark scores for different models and capabilities CREATE TABLE Benchmarks (     BenchmarkID INT PRIMARY KEY,     ModelID INT,     Capabil...

SQL Case Study 92.7 BIG FM Radio Network

Image
                                                                        92.7 BIG FM Radio Network Digits n Data -  https://nitish2162001.github.io/webpa/#sql-schema   SQL CHALLENGE -  Digits n Data  -  https://nitish2162001.github.io/webpa/#sql-schema SQL CHALLENGE - 92.7 BIG FM radio network Tables names: Stations Hosts Shows Partnerships ShowPartnerships Awards OnlinePresence Schema: SQL Schema                            CREATE TABLE Stations (                                 StationID INT PRIMARY KEY,                             ...