All categories

3 years ago

Using SQL

Computers and Technology

1 answer:

lesantik [10]3 years ago

7 0

Answer:

Following are the code to this question:

/*using the select statement, that selects column name from the table blog.posts */

SELECT blog.posts.user_id, blog.posts.body, users.name/*column name user_id, body, name*/

FROM blog.posts/* use table name blog.posts*/

RIGHT OUTER JOIN users ON blog.posts.user_id = users.id;/*use right join that connect table through user_id*/

Explanation:

In the structured query language, RIGHT JOIN is used to recovers from both the right side of the table both numbers, although the left table has no sets. It also ensures that even if the 0 (null) documents are linked inside this left table, its entry will always return the outcome row, but still, the number of columns from its left table will be NULL.

In the above-given right join code, the select statements used that selects the column names "user_id, body, and the name" from the table "blog. posts" and use the right join syntax to connect the table through the id.

You might be interested in

Which of the following statements should be avoided when developing a mission statement?

Citrus2011 [14]

Answer: The how-to statements

Explanation:

The mission statement is simply a short summary of the purpose of a company. It is the guideline on how a company will operate. The mission statement states the reason for the existence of a company, products sold or service rendered and the company's goals.

The mission statement should be brief but comprehensive, consist of simple words and describe the “who, what, and where” of the organization.

Therefore, the incorrect option based on the explanation above is "The how-to statements". This shouldn't be part of the mission statement.

3 0

3 years ago

Which one of the following terms is defined as the material and surfaces upon which an artist works?

katrin [286]

Media is the surface or material that an artist works on

5 0

3 years ago

Write a program that grades arithmetic quizzes as follows: Ask the user how many questions are in the quiz. Ask the user to ente

kirill115 [55]

Answer:

The program in C++ is as follows:

#include <iostream>

using namespace std;

int main(){

int questions, answer;

cout<<"Questions: ";

cin>>questions;

int answerkey[questions];

cout<<"Enter answer keys: ";

for(int i = 0; i< questions; i++){

cin>>answerkey[i]; }

int correct = 0;

cout<<"Enter answers: ";

for(int i = 0; i< questions; i++){

cin>>answer;

if(answer == answerkey[i]){

correct++; } }

cout<<"Correct answers: "<<correct<<endl;

cout<<"Percentage correct : "<<(100 * correct)/questions<<"%";

return 0;

}

Explanation:

This declares the number of questions and the answers submitted to each equation

int questions, answer;

Prompt to get the number of questions

cout<<"Questions: ";

This gets input for the number of questions

cin>>questions;

This declares the answerkey as an array

int answerkey[questions];

Prompt to get the answer key

cout<<"Enter answer keys: ";

This iteration gets the answer key for each question

for(int i = 0; i< questions; i++){

cin>>answerkey[i]; }

This initializes the number of correct answers to 0

int correct = 0;

Prompt to get the enter the answers

cout<<"Enter answers: ";

This iterates through the answer keys

for(int i = 0; i< questions; i++){

This gets the answer to each question

cin>>answer;

This compares the answer to the answer key of the question

if(answer == answerkey[i]){

If they are the same, correct is incremented by 1

correct++; } }

Print the number of correct answers

cout<<"Correct answers: "<<correct<<endl;

Print the percentage of correct answers

cout<<"Percentage correct : "<<(100 * correct)/questions<<"%";

7 0

3 years ago

What is cryptocurrency ? I need to do a research one it please help!

icang [17]

A cryptocurrency is a digital asset designed to work as a medium of exchange that uses strong cryptography to secure financial transactions, control the creation of additional units, and verify the transfer of assets.

8 0

3 years ago

If you hold down the alt key and click anywhere in your document what happens

sukhopar [10]

The Alt key on a PC is utilised to change the capacity of other squeezed keys. It will go to any desired short cut in the computer that is being accessed. in short , one can use this to reach other functionality of a windows based computer easily. For example, if you were accessing documents and you want to skip to a different function from what you were doing on the desktop.

4 0

3 years ago