Floral Data Quiz

A vibrant floral arrangement with various flower colors and SQL code snippets artistically integrated into the background, showcasing a creative blend of nature and technology.

Floral Data Quiz

Test your SQL knowledge with our engaging Floral Data Quiz! This quiz consists of three challenging questions focused on customer orders and flower attributes.

Can you identify the right SQL queries to:

Find customers who are no longer buying.
Select flowers based on color criteria.
Determine maximum order prices.

3 Questions1 MinutesCreated by QueryFlower123

Select customer who is not buying any more .

select Customer_id from Flower where Customer_id not in (select Customer_id from Orders );

Select Customer_id from Customer where Customer_id not in (select Customer_id from Orders );

Select Customer_id from Customer where not in (select Customer_id from Orders );

Flower_id that it color finish with letter 'k'

select Flower_id from Flower where Flower_color like 'k'

Select Flower_id from Flower where Flower_color like '%k' ;

Select the maximum total price of flowers orders.

Select max(Total_price) From Orders ;

Select min(Total_price) From Orders ;

Select sum(Total_price) From Orders ;

{"name":"Floral Data Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your SQL knowledge with our engaging Floral Data Quiz! This quiz consists of three challenging questions focused on customer orders and flower attributes.Can you identify the right SQL queries to:Find customers who are no longer buying.Select flowers based on color criteria.Determine maximum order prices.","img":"https:/images/course5.png"}