The solution is software commands for sql and via: https://www.w3schools.com/sql/trysql.asp? Filename = trysql_select_all

1- Find the product name, product number and price from the products table and search the price is greater than or equal to 10 and the price is less than or equal to 90 and the product number is greater than or equal to 4 and less than or equal to 17 and arrange all the data according to the name of the product And the price is from smallest to largest 2- Find the employee's name, employee number and employee photo from the employee table for employees whose date of birth ranges between 1950 and 1960 and arrange the results according to the youngest date of birth and the employee's name in descending order 3- Find the last name and date of birth from the employee table and search for employees whose date of birth is less than or equal to the date "01-01-1960" on the condition that their names begin with the letter "c" arranged by the largest date of birth 4- Find the product name, product number and price from the products table arranged by the smaller product number 5- Find the product name, product number, and price from the products table, provided that the price is greater than or equal to 20 and the price is less than or equal to 100 arranged according to the higher price 6- Finding all the data from the orders table arranged according to the order number 7- Finding the order number, supplier number and order date from the supplier's order list from No. 4 to No. 20, suppliers from 30 to 90 arranged according to the date of the order 8- Find the number of orders and the date of the order from the order table for orders that took place between 1960 and 1990, arranged according to the date of the oldest order 9- Finding the order number, the shipper number and the order date from the order table for shipper number 3, arranged according to the date of the lowest order 10-Find the order number, the supplier number, and the shipper number from the order table for the shipper between the number 3 and the number 10 arranged according to the shipper number Descending 1- Find the product name, product number and price from the products table and search the price is greater than or equal to 10 and the price is less than or equal to 90 and the product number is greater than or equal to 4 and less than or equal to 17 and arrange all the data according to the name of the product And the price is from smallest to largest 2- Find the employee's name, employee number and employee photo from the employee table for employees whose date of birth ranges between 1950 and 1960 and arrange the results according to the youngest date of birth and the employee's name in descending order 3- Find the last name and date of birth from the employee table and search for employees whose date of birth is less than or equal to the date "01-01-1960" on the condition that their names begin with the letter "c" arranged by the largest date of birth 4- Find the product name, product number and price from the products table arranged by the smaller product number 5- Find the product name, product number, and price from the products table, provided that the price is greater than or equal to 20 and the price is less than or equal to 100 arranged according to the higher price 6- Finding all the data from the orders table arranged according to the order number 7- Finding the order number, supplier number and order date from the supplier's order list from No. 4 to No. 20, suppliers from 30 to 90 arranged according to the date of the order 8- Find the number of orders and the date of the order from the order table for orders that took place between 1960 and 1990, arranged according to the date of the oldest order 9- Finding the order number, the shipper number and the order date from the order table for shipper number 3, arranged according to the date of the lowest order 10-Find the order number, the supplier number, and the shipper number from the order table for the shipper between the number 3 and the number 10 arranged according to the shipper number Descending