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

Write a function named dice_eval that accepts two parameters representing numeric dice values and returns a string describing th

Zigmanuir [339]

Following are the "dice_eval" method code into python language.

Program Explanation:

Defining a method "dice_eval" that takes two variables "d1,d2" in its parametes.
Inside the method, multiple conditional statements were used that adds the parameter values and calculates its value which can be defined as follows:
In the if block, it adds the parameters and uses or gate that check its value that is equal to 7 or 11. so, it will return a string message that is 'Winner!'.
In the elif block, it adds the parameters and uses or gate that check its value that is equal to 2 or 3 or 12. so, it will return a string message that is ' C r aps ! '.
In the else block, it uses a return keyword that adds parameter value and prints a string value.
Outside the method "d1,d2" is declared that inputs the value from the user-end, and passes the value into the method, and prints its value.

Program:

def dice_eval(d1, d2):#defining a method dice_eval that takes two parameters

if (d1+d2)==7 or (d1+d2)==11:#defining if block that adds parameter value and use or operator to check its value

return 'Winner!'#return string value

elif (d1+d2)==2 or (d1+d2)==3 or (d1+d2)==12:#defining elif block that adds parameter value and use or operator to check its value

return 'C r aps!'#return string value

else:#defining else block

return 'Point is '+str(d1+d2)#return string value with adding parameter

d1=int(input())#defining d1 that input value

d2=int(input())#defining d2 that input value

print(dice_eval(d1,d2))#calling method and print its return value

Output:

Please find the attached file

Please find the complete code in the attached file.

Learn more:

brainly.com/question/15011927

4 0

3 years ago

A network technician configures a firewall’s ACL to allow outgoing traffic for several popular services such as email and web br

Cerrena [4.2K]

Answer: (B) Allow the firewall to accept inbound traffic to ports 80, 110, 143, and 443

Explanation:

Port 80 is used by HTTP, 110 by pop3 to retrieve emails from web servers, 143 by imap for internet messaging and 443 is used for TCP for websites using SSL. So if the firewall is allowed to accept inbound traffic to these ports 80,110,143 and 443 then it would be possible to retrieve emails.

3 0

3 years ago

What is the name of the subsystem that transfers data between components inside a pc or between pcs?

Nana76 [90]

<span>What is the name of the subsystem that transfers data between components inside a pc or between pcs? The Answer is the BUS</span>

4 0

3 years ago

Determine if the following identifiers are valid. If they are invalid, state the reason. For example, the identifier min value i

Natasha2012 [34]

Answer:

Explanation:

Determine if the following identifiers are valid. If they are invalid, state the reason. For example, the identifier min value is invalid as it uses a whitespace.

road

mid_point

8ball

break

_log_value

EVERY1

[email protected]

_log

NewNumber

$varA

class

4 0

3 years ago

In order to average together values that match two different conditions in different ranges, an Excel user should use the _____

ololo11 [35]

Answer:

The answer to this question is the "SUMIFS" function.

Explanation:

The SUMIFS function is a part of Microsoft Excel. It is used to add the number of multi-criteria cells. This function supports logical operators and wildcards. The main purpose to use this function provides a sum of cells with match multiple criteria. The syntax of this function can be given as:

Syntax:

=SUMIFS (sum_ranges, range_1, criteria_1, [range_2], [criteria_2], ...)

In the above syntax, we use 5 arguments in function that can be defined as:

The sum_range argument is used to sum of range to be summed.
The range_1 and range_2 arguments are stands for first and second ranges for evaluating. In which the range_2 can be optional.
The criteria_1 and criteria_2 is used in range, which are range_1 and range_2.

7 0

3 years ago