Print Standard Body Temperature in Fahrenheit

Beginner

In this project, you will learn how to convert the standard body temperature from Celsius to Fahrenheit and round it down to the nearest whole number using SQL statements in the MySQL client.

SQLMySQL

Introduction

In this project, you will learn how to convert the standard body temperature from Celsius to Fahrenheit and round it down to the nearest whole number using SQL statements in the MySQL client.

👀 Preview

MariaDB [(none)]> SOURCE /home/labex/project/Fahrenheit.sql;
+---------------------------+
| Standard Body Temperature |
+---------------------------+
|                        99 |
+---------------------------+
1 row in set (0.000 sec)

🎯 Tasks

In this project, you will learn:

  • How to access the MySQL database using the sudo command without any password
  • How to write an SQL statement to convert the standard body temperature of 37 degrees Celsius to Fahrenheit
  • How to round the Fahrenheit temperature down to the nearest whole number
  • How to save the SQL statement in a script file and run it in the MySQL client

🏆 Achievements

After completing this project, you will be able to:

  • Understand the conversion between Celsius and Fahrenheit for body temperature
  • Write SQL statements to perform basic data manipulation tasks
  • Run SQL scripts in the MySQL client to execute SQL statements
  • Demonstrate your understanding of SQL and database management concepts

Teacher

labby

Labby

Labby is the LabEx teacher.