A-List the information contained in the SaleItem table plus the product name and category concerning the sales of sneakers and the sales of casual shoes (categories) whose sale price is equal to $100. (Categories are not capitalized in the database.) Note: Your answer should dynamically include all current columns in SaleItem and any future changes to columns, plus the product name and category.

B-List Salaried employees whos salary is greater than $40,000. Show Employee first name, last name, hiredate and salary. Sort the data by hire date.

<code>SELECT
si.id,
si.product_id,
si.price,
p.name,
c.category
FROM SaleItem si
JOIN Product p ON si.product_id = p.id
JOIN Category c ON p.category_id = c.id
WHERE
c.category IN ('sneakers', 'casual shoes') AND
si.price = 100
</code>

What is program?
A computer utilises a set of instructions called a program to carry out a particular task. A program is like the recipe for a computer, to use an analogy. It includes a list of components (called variables, which can stand for text, graphics, or numeric data) and a list of instructions (called statements), which instruct the computer on how to carry out a certain activity.

Specific programming languages, such C++, Python, and Ruby, are used to construct programmes. These are high level, writable, and readable programming languages. The computer system's compilers, interpreters, or assemblers subsequently convert these languages into low level machine languages.

To learn more about program
https://brainly.com/question/28717367
#SPJ4