This is not to be tried in PostgreSql, because there are no data provided. You can write a handmade code solution by what you think would work.

- Suppose that you would have tables Athletes, Activities and Scores in your PostgreSQL database. How would you build a query to retrieve the information requested at the end of the second page? Write down the code based on the given information of the tables themselves, where are given attributes (columns), keys and everything included. You can use select, join, where, whatever needed.

SQL Form code that would solve the following request Suppose you have these 3 tables in your database CREATE TABLE Athletes ( IDINT, name VARCHAR (50), gender CHARCI, height FLOAT, Primary KEY (ID) CREATE TABLE Activities ( ID INT name VARCHAR (50), record FLOAT PRIMARY KEY (ID) UNIQUE (name) CREATE TABLE Scores ( athleteID INT, activity ID INT, result FLOAT, PRIMARY Key (athlete Io, activity ID), FOREIGN KEY (athlete IA REFERENCES Athletes (1) FOREIGN KEY (activity IO) REFERENCES Activities (TO) ); Now write PostgreSQL commands that you think would work in order to retrieve the information requested below. You should malce the querie os simple as you possible can. - The I) and name of each athlete that has at least 5 results in one of the activities that goes by the name "100 m dash", their best result, along with the difference between the record and their best result, the second to last column should be named "best" while the last column should be named difference". Also, the last column should be formatted to show at least 1 digit before the decimal point and exactly 2 digits after the decimal point. SQL Form code that would solve the following request Suppose you have these 3 tables in your database CREATE TABLE Athletes ( IDINT, name VARCHAR (50), gender CHARCI, height FLOAT, Primary KEY (ID) CREATE TABLE Activities ( ID INT name VARCHAR (50), record FLOAT PRIMARY KEY (ID) UNIQUE (name) CREATE TABLE Scores ( athleteID INT, activity ID INT, result FLOAT, PRIMARY Key (athlete Io, activity ID), FOREIGN KEY (athlete IA REFERENCES Athletes (1) FOREIGN KEY (activity IO) REFERENCES Activities (TO) ); Now write PostgreSQL commands that you think would work in order to retrieve the information requested below. You should malce the querie os simple as you possible can. - The I) and name of each athlete that has at least 5 results in one of the activities that goes by the name "100 m dash", their best result, along with the difference between the record and their best result, the second to last column should be named "best" while the last column should be named difference". Also, the last column should be formatted to show at least 1 digit before the decimal point and exactly 2 digits after the decimal point