Answer:
SELECT inventory_id, film_id, title, store_id, address_id
FROM Inventory.Inventory
JOIN Business.store ON Inventory.store_id = store.store_id
JOIN Business.rental ON rental.film_id = Inventory.film_id
JOIN film_text ON Inventory.film_id = film_text.film_id
WHERE COUNT(rental_id) = 0;
Explanation:
The JOIN clause is also used to query tables from two databases. The Inventory and the Business database are joined in the inventory and store table respectively. The Query also joins the inventory table and the film_text table to get the title or name of the film rented where the rental_id count is equal to zero.
When the increment or decrement operator is placed before the operand (or to the operand's left), the operator is being used in prefix mode. Postfix mode on the other hand is when the increment or decrement operator is placed after the operand (or to the oper and's right) .
Answer:
The answer to this question is given below in the explanation section.
Explanation:
This question is about what is a good analogy for explaining the actions of a compiler? The correct option is <u> automatic programming of kitchen devices
.</u>
<u>
</u>
a hybrid ability of a car to use multiple energy sources (false)
this analogy is not correctly mapped on the compiler, becuase the compiler can be designed only for one type of language, for example, the program that calculates the average of students number can be easily programmed in C++ and in C#. But you cannot compile the C# program in C++ compiler and vice versa.
a street map of a local subdivision (false)
Because you can design a compiler for a not specific subdivision of programming.
an interpreter who speaks several languages
it is not an analogy, however, an interpreter can handle only one type of language.
an automatic programming of kitchen devices (true)
This is a good analogy of compiler because you give input to the device and that device based on your input gives you back an output. Similarly, you give input to the compiler in form of language syntax, and it automatically give you output based on your input.
Answer:
#include <bits/stdc++.h>
using namespace std;
int main() {
int A[3][3],B[3][3],res[3][3],i,j;
srand(time(0));//for seed.
for(i=0;i<3;i++)
{
for(j=0;j<3;j++)
{
int val=rand()%100+1;//generating random values in range 1 to 100.
int val2=rand()%100+1;
A[i][j]=val;
B[i][j]=val2;
}
cout<<endl;
}
for(i=0;i<3;i++)
{
for(j=0;j<3;j++)
{
res[i][j]=0.5*A[i][j]+3*B[i][j];//storing the result in matrix res.
}
}
cout<<"Matrix A is"<<endl;
for(i=0;i<3;i++)
{
for(j=0;j<3;j++)
{
cout<<A[i][j]<<" ";//printing matrix A..
}
cout<<endl;
}
cout<<"Matrix B is"<<endl;
for(i=0;i<3;i++)
{
for(j=0;j<3;j++)
{
cout<<B[i][j]<<" ";//printing matrix B..
}
cout<<endl;
}
cout<<"The result is"<<endl;
for(i=0;i<3;i++)
{
for(j=0;j<3;j++)
{
cout<<res[i][j]<<" ";//printing the result..
}
cout<<endl;
}
return 0;
}
Output:-
Matrix A is
13 95 83
88 7 14
24 22 100
Matrix B is
11 13 95
48 35 20
68 100 18
The result is
39.5 86.5 326.5
188 108.5 67
216 311 104
Explanation:
I have created 2 matrices A and B and storing random numbers int the matrices A and B.Then after that storing the result in res matrix of type double to store decimal values also.Then printing the res matrix.