Answer:
SELECT DISTINCT VendorName FROM Vendors
WHERE VendorName= ANY (SELECT VendorName FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID) ORDER BY VendorName;
Explanation:
All bold faced words are sql keywords for different purposes. The subquery return the all values which matches the join condition and main query will choose only distinct values and make them in order of VendorName.
There many other queries also return the same result as returned by given query.
Answer:
Line of sight and rules of composition
Explanation:
He needs the rules of composition in order to use the line of sight
The stage of systems development in
which design specifications (such as the architecture, the modules, the interfaces,
and the data) are created is the stage of systems design. The purpose of systems
design is primarily to satisfy the specified requirements.
Answer:
- Copyright
- Defamation
- Cyberbullying
Explanation:
The first issue, that I would like to explain is Copyright. If you are imposing as a company on Social Media with a real name that is Copyrighted, the company will file a DMCA takedown notice which is the Digital Millennium Copyright Act
. Which can result in your Social Media being taken down, or by getting a fine, sued or even jailtime.
The second issue is Defamation, what Defamation is basically spreading false information about a company / business in real or online that hurts a companies reputation. If you commit this crime online you can face a lawsuit or even jailtime for one year.
Thirdly, cyberbullying. This is illegal in most states in the US. Cyberbullying is a serious matter and depending on your states laws can be charged with criminal harassment.
Sources:
Quora: (Website)
Miclaw: (Website)
Statista: (Website)
