Answer:
select s.sname from supplier s,product p,supply su where s.s#=su.s# and p.p#=su.p# and p.p_name like 'chairs' and p.price>300
Explanation:
First of all, we need to select all the required columns from the specific tables so that the data in those columns can be display by executing this SQL query.
As the task at hand is to find all supplier names and cities who supply expensive chairs therefore we need to join three tables in order to look for the supplier name selling the highest prices.
In the above SQL query, the conditons "s.s#=su.s# and p.p#=su.p#" will join tables and the conditons "p.p_name like 'chairs' and p.price>=300" will be used to search for the chair with price greater than $300.
TEETEE TEE TEE TEE TEETEETEE
Answer:
RAM provides much faster accessing speed to data than secondary memory. By loading software programs and required files into primary memory(RAM), computer can process data much more quickly. Secondary Memory is slower in data accessing. Typically primary memory is six times faster than the secondary memory.
Answer:
The advantages of using a separate CSS file rather than embedding the CSS code inside the HTML file include: The layout of a web page is better controlled. Style (CSS) kept separate from structure (HTML), means smaller file size. Reduced file size means reduced bandwidth, which means faster loading time.
The program is called exel. It allows you to have spread sheets.
