Answer:
SELECT product_name, amount_due, amount_paid,
cancelled, amount_refunded
FROM products
ORDER BY product_name ASC;
Explanation:
SQL (Structured Query Language ) was used above.
The SELECT command is used to list all the variables we want in our output.
The FROM command signifies the location.
ORDER BY command ensures that your result is ordered
ASC means Ascending Order.
; signifies the end of the query.
NOTE: Underscores were used because variables cannot be written with spaces between them
Answer:
Check the explanation
Explanation:
223.1.17/24 indicates that out of 32-bits of IP address 24 bits have been assigned as subnet part and 8 bits for host id.
The binary representation of 223.1.17 is 11011111 00000001 00010001 00000000
Given that, subnet 1 has 63 interfaces. To represent 63 interfaces, we need 6 bits (64 = 26)
So its addresses can be from 223.1.17.0/26 to 223.1.17.62/26
Subnet 2 has 95 interfaces. 95 interfaces can be accommodated using 7 bits up to 127 host addresses can represented using 7 bits (127 = 27)
and hence, the addresses may be from 223.1.17.63/25 to 223.1.17.157/25
Subnet 3 has 16 interfaces. 4 bits are needed for 16 interfaces (16 = 24)
So the network addresses may range from 223.1.17.158/28 to 223.1.17.173/28
Answer:
1. More access to data
2.convenience
3. Easy creation of BI solutions
4. Report creation
5. Saves time
Explanation:
A data warehouse can be described to be an electronic storage system that contains large amount of facts and information which sources for and also maintains data from different sources; either external or internal.
The most important reason for a data warehouse is for it to store great amounts of data to be used for query and also to be used for analysis.
Why do we use a data warehouse?
1. Users have more access to data due to the integration of various sources of data. It makes use of real time data facts
2. You can conveniently store and also create metadata
3. Business intelligence solutions can easily be created using data warehouses.
4. Users can easily create their own reports
5. Data warehouses makes accessing different data sets faster. It is a time saver as business users are not going to spend time trying to retrieve data from various sources.
Answer:
range of colors that a color device can be display or print.a color that may be displayed on your monitior in rgb may not be printable in the gamut of your cmyk printer
