Question

Тoday a customer want a cake set that has minimal calories.
Write a query to sort the cakes by calorie count and select the first 3 cakes from the list to offer the customer.

Answer 1

Answer:

select * from cakes -- it will retrieve all the information from the table.(cakes)

order by calories --order by will select to sort and return the data

limit 3 ; --limit is limit .(-- is used as a comments in SQL).

SQL is insensitive so you write queries in any case(upper, lower).

SQL

Data query language (DQL), data definition language (DDL), data control language (DCL), and data manipulation language are some of the more popular forms of statements in SQL, which was originally based on relational algebra and tuple relational calculus (DML). [c][7] Data query, data manipulation (insert, update, and delete), data definition (schema development and change), and data access control are all included in the scope of SQL. Despite being primarily a declarative language (4GL), SQL also has procedural components.

Edgar F. Codd's relational model was one of the first commercial languages to be used. His seminal 1970 paper, "A Relational Model of Data for Large Shared Data Banks," described the model. [8] Even though it doesn't entirely follow the relational model as it's described

See more:

https://brainly.in/question/51277520

#SPJ1