All categories

4 years ago

Using SQL

Computers and Technology

1 answer:

lesantik [10]4 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

Your employer's right to electronically monitor you is an issue of ____.

Cloud [144]

Answer: Employee privacy

Explanation:

Employers can electronically monitor property, computer and electronic devices under the their rights in the organization but there is issue of employee privacy. As, employee has the right to privacy in the organization or workplace.

In some organization phones and email address are provided by the company so that they can electronically monitor the employee properly. In this case, some employee feel that monitoring is the violation of their personal and privacy rights.

8 0

3 years ago

_____ assures the interface will act as the users expect, while _____ assures it will look pleasing. Select one:

Agata [3.3K]

Answer:

C. consistency, aesthetics

Explanation:

Based on the descriptions given to us in the question we can deduce that the answer is C. consistency, aesthetics. This is because "consistency" is defined as something that always delivers the same results, which is what users need from the interface in order to understand it and continue using it. While "aesthetics" is defined as the visual representation of something (how something will look).

I hope this answered your question. If you have any more questions feel free to ask away at Brainly.

7 0

3 years ago

The Next Einstein Initiative and the ________ Institute for Mathematical Sciences bring bright young learners and the best lectu

Degger [83]

Answer:

The correct answer is B. Africa

Explanation:

African Institute for Mathematical Sciences (AIMS) was founded in 2003 having its first center in Cape Town, South Africa. AIMS provides training for Africa's talented university graduates needed to enter technical professions or pursue graduate studies in technical fields. The Next Einstein Initiative (NEI) is a strategic plan to build on the success of the first AIMS centre and create a coordinated pan-African network of 15 AIMS centres by 2020, producing 750 well-qualified graduates per annum. AIMS won the Google's Project 10^100 and also the founder of AIMS won the TED Prize and announced his vision to unlock scientific talent across Africa.

5 0

4 years ago

Write a program that prompts the user to enter a series of numbers between 0 and 10 asintegers. The user will enter all numbers

Anna71 [15]

Answer:

The program in Python is as follows:

import collections

from collections import Counter

from itertools import groupby

import statistics

str_input = input("Enter a series of numbers separated by space: ")

num_input = str_input.split(" ")

numList = []

for num in num_input:

if(num.lstrip('-').isdigit()):

if num[0] == "-" or int(num)>10:

print(num," is out of bound - rejecting")

else:

print(num," is valid - accepting")

numList.append(int(num))

else:

print(num," is not a number")

print("Largest number: ",max(numList))

print("Smallest number: ",min(numList))

print("Range: ",(max(numList) - min(numList)))

print("Mode: ",end = " ")

freqs = groupby(Counter(numList).most_common(), lambda x:x[1])

print([val for val,count in next(freqs)[1]])

count_freq = {}

count_freq = collections.Counter(numList)

for item in count_freq:

print(item, end = " ")

lent= int(count_freq[item])

for i in range(lent):

print("#",end=" ")

print()

Explanation:

See attachment for program source file where comments are used as explanation. (Lines that begin with # are comments)

The frequency polygon is printed using #'s to represent the frequency of each list element

7 0

3 years ago

Explain how the number of jobs available to workers has been affected by the use of ICT in commerce and industry, using specific

blondinia [14]

Answer:

The main cause of lack of jobs is due to automation and the ability for computers to do everything faster, more efficiently and effectively.

Explanation:

A specific example - Data entry jobs are redundant from automation programs

- Economic Forum predicted a net increase of 58 million jobs for automation, so this accounts for losses but isn't case specific to data entry

6 0

2 years ago