Computer scienceFundamentalsSQL and DatabasesBasics SQLIntroduction to SQL

Basic data types in SQL

Theory

Create Patients table

Report a typo

Create a table called Patients with the following columns:

  • patient_id (integer)

  • first_name (30 characters or less)

  • last_name (30 characters or less)

  • temperature (not higher than 100°C with no more than one digit after the decimal point)

  • is_discharged (indicates if a patient was discharged or not)

Use the DECIMAL() function to limit the number of digits in temperature.

Write an SQL statement





___

Create a free account to access the full topic