Chủ Nhật, 2 tháng 9, 2018

Waching daily Sep 3 2018

 Meghan Markle has remained silent on the issues her father Thomas Markle has raised with the press

 Thomas has done a number of media interviews, including a Good Morning Britain interview with Piers Morgan

 In one, he claimed to give details of a conversation he had with Prince Harry concerning Brexit and Donald Trump

 This was despite the fact the royal family by protocol remain apolitical. In contrast, the Duchess of Sussex has said nothing in response to her father

 But why has Meghan chosen to remain silent? It is said she has not commented publicly on the matter because it is a "family" matter, and not related to her royal role

 Meghan has behaved "quite rightly," former royal butler Grant Harrold told Express

co.uk. "This is a personal family matter, and I see no right in it being aired in the press at all

 "The Duchess of Sussex has quite rightly remained silent, as it has nothing to do with anyone but her paternal family

 "I am sure The Duchess of Sussex will be very tight lipped over any family matters as any of us would be

"  It is also possible that royal protocol – which involves not having social media and making announcements through Palace statements – prevents Meghan from speaking out

 A source told US Weekly: "She doesn't have her own publicist, she can't make any comments on Twitter and she can't reach out to him to tell him to stop speaking to the press

" This is despite the fact "[Meghan's] father's comments have an effect on everything," the publication reported

 Earlier this week, it was said Kate Middleton is looking out for Mehgan Markle amid her family drama with Thomas Markle

 Her father Thomas Markle was asked to walk Meghan down the aisle before being embroiled in a scandal involving a series of staged photographs

 In his latest interview with the Mail on Sunday the 74-year-old claimed he has been cut off from his daughter and said: "I used to have a phone number and text number for her personal aides at the Palace, but after I said a few critical words about the Royal Family changing Meghan, they cut me off

" He added that Meghan "would be better off if he died". Now sources have claimed that Kate Middleton is rallying round her new sister-in-law in the wake of this latest news

 The source told Vanity Fair: "Kate's well aware of what Meghan is going through. "Her family has been dragged through the tabloids and she knows it's not nice

 "She's made a big effort to be kind to Meghan and look out for her."

For more infomation >> Why Meghan Markle has remained silent while family talks to press – is it royal protocol? - Duration: 3:20.

-------------------------------------------

What is the total length of all the films added together?/SQL COUNT, SUM/SQL Tutorial/Eng, Kor Sub - Duration: 1:59.

We need to find the number of all the columns in the address table.

Write COUNT after SELECT to find the number of columns

Add (*) after COUNT to show all columns

FROM address (this is the table name)

Hit F5 to run the query!

Next, we want to find the number of specific columns in the address table

Write SELECT COUNT like before, and the specific column name inside the parenthesis

and add FROM address

Hit F5 to run the query!

How about finding the number of all columns with rental duration in the film table?

Write SELECT COUNT

Write rental_duration inside the parenthesis

FROM film

Hit F5 to run the query!

This time, we're going to use DISTINCT to see the number of unique values

Write SELECT COUNT first,

Add DISTINCT and rental_duration

FROM film

Hit F5 to run the query!

Okay, now let's find the total length of all the films in the film table

Write SELECT and then SUM

Write length inside the parenthesis

FROM film

Hit F5 to run the query!

Now we're going to divide it by 60 to see the result in hours and name the new column 'entire_hour'

Write SELECT SUM(length)

Add '/60' to divide the value

And finally add AS entire_hour

FROM film

In our final example, we'll find the number of an unique value: replacement_cost

Write SELECT COUNT

Add DISTINCT to see the number of unique values (DISTINCT replacement_cost)

FROM film

Hit F5 to run the query!

Không có nhận xét nào:

Đăng nhận xét