Answer:
CREATE VIEW [product_summary] AS
SELECT product_id , order_count , order_total FROM Product;
SELECT * FROM [product_summary] ;
Explanation:
- First of all, use the CREATE VIEW syntax to create a view named product_summary that includes the product_id, order_count, order_total columns and returns the summary information about each product.
- Use SELECT statement to return all the columns from the product_summary view.
Answer:
Program for measurement in meters and then converts it into miles, feet, and inches:
#include<iostream.h>
#include<conio.h>
void main()
{ float meter, mile, feet, inches;
cout<<"enter meters";
cin>>meters";
feet=meter×3.2808;
mile= meter×0.000621371;
inches= meter×39.3701;
cout<<"Value of"<<meter<<"meter"<<"in feet is"<<feet<<"feet":
cout<<"Value of"<<meter<<"meter"<<"in mile is"<<mile<<"mile";
cout<<"Value of"<<meter<<"meter"<<"in inches is"<<inches<<"inches";
getch();
}
Answer:
D
Hope This Helps! Have A Nice Day!!
