Carter | thin layer of extension methods | Dependency Injection library

Im trying to find the distributor with the highest and lowest quantity for each country in two columns distributor with minimum quantity and maximum quantity I have been able to get the information from other posts but it is in a column however I want it on a row per country

See http://sqlfiddle.com/#!17/448f6/2

Desired result

...

I want to replace all the quoted strings in a blankets into double quoted strings in the PostgreSQL.

This is my current scripts and sample input.

...

I am trying to figure out how to limit the range when using onSelectionChange. I have had some limited success with a few other onSelectionChange answers here but can't quite get it to do what I need..

Here is my Sample Sheet outlining what I am trying to accomplish...

GOAL: I would like the onSelectionChange(e) to get the values in Col A:F in the selected row, IF the selected cell is in the named range of TESTsheet!A10:F (selecting any cell in rows 1-9 would not return any values)

The values from the selected row would be set in spisific cells.

For example: If any cell in row 11 Col A-F was selected, the values from A11, B11, C11, D11, E11, F11 would be set in B2, B4, B6, E2, E4, E6.

Here is an example.

if row 11 is selected (the data in row 11 is copied to cells in rows 1,3,5):

A B C D E F 1 First Name Sean DEPT Physics 2 3 Last Name Smith STATE AK 4 5 ID No. 4685 YEAR 2006 6 7 8 --- --- --- --- --- --- 9 1ST NAME LAST NAME ID No. DEPT STATE YEAR 10 Robert Jones 1587 Art MA 1970 11 Sean Smith 4685 Physics AK 2006 12 Karen Davis 6985 English NY 1987 13 Olivia Carter 7985 Math CA 2019 14 Ellen James 3587 Music NH 1999

//

//

if row 14 is selected

(the data in row 14 is copied to cells in rows 1,3,5):

A B C D E F 1 First Name Ellen DEPT Music 2 3 Last Name James STATE NH 4 5 ID No. 3587 YEAR 1999 6 7 8 --- --- --- --- --- --- 9 1ST NAME LAST NAME ID No. DEPT STATE YEAR 10 Robert Jones 1587 Art MA 1970 11 Sean Smith 4685 Physics AK 2006 12 Karen Davis 6985 English NY 1987 13 Olivia Carter 7985 Math CA 2019 14 Ellen James 3587 Music NH 1999

//

//

I have gotten close with these answers:

• onSelectionChange to display the value of the selected cell reference on another tab in Google Sheets
• onSelectionChange for a specific Google Sheets tab

...

I was given a task where I'm supposed to plot a element based on another column element.

For further information here's the code:

...

While returning data from laravel routes or controllers, they are automatically returned as JSON data. That's cool but reading these data into the web page it's difficult. Because they're inline, and it's hard to identify elements. I know I could use something like: https://jsonformatter.curiousconcept.com/#. To format the json data to be readable. But I was wondering if this could be done into the laravel web route or controller?

The route below is part of web.php file. Also use Illuminate\Support\Facades\DB;.

...

I have a pandas dataframe of stats from 4 NBA seasons where seasons starts from 2017-18 and has been converted into dummy variables as seen below.

...

Im working through some self-join examples and I am drawing a blank on the following example. Its the last example at the following link Self-Join Example

...

I have 50 lists in a py file and I am wondering if there's a way to import and make some of them into a dictionary - meaning only taking 48 lists into the dictionary. I can add it one by one through dict(zip()) but this means that I need to provide a long list of the list names and the lists themselves. Is there a more scaleable way I can achieve what I want?

...

Let's say I have 3 tables: users, customattributes, and customattributevalues. End user can add custom attributes by selecting a name and type for the attribute, and the edit the values for any user.

Here are my users:

id firstname lastname active datecreated username email 3 Ellen Ripley 1 3/25/2235 78439 Rip8439@Weyland-Yutani.com 5 Johnny Rico 1 4/16/2675 Roughneck31 RicoJ31@Roughnecks.com

customattributes (can be added to anytime)

id fullname uniquename type 1 Hire Date hiredate date 2 Employee ID eeid int 3 Supervisor supervisor nvarchar(50) 4 Assigned Ship assignedship nvarchar(50) 5 Job Title jobtitle nvarchar(50)

type I currently have as sysname datatype.

customattributevalues (can be edited anytime)

id attributeid userid value 1 1 3 2335-03-25 2 2 3 78439 3 3 3 Burke, Carter 4 4 3 Sulaco 5 5 3 Consultant 6 1 5 2675-04-16 7 2 5 78440 8 3 5 LT Rasczak 9 4 5 Rodger Young 10 5 5 Private

value I currently have as sql_variant datatype

So here is my question: how can I create a report that shows all employees and their attributes, 1 line per employee, without knowing how many custom attributes there are --and-- crucially, I want to explicitly convert each column to the correct data type

Desired output:

firstname lastname datecreated username email Hire Date Employee ID Supervisor Assigned Ship Job Title Ellen Ripley 2235-03-25 78439 Rip8439@Weyland-Yutani.com 2335-03-25 78439 Burke, Carter Sulaco Consultant Johnnie Rico 2675-04-16 Roughneck31 RicoJ31@Roughnecks.com 2675-04-16 78440 LT Rasczak Rodger Young Private

I've already learned to do the dynamic column headers using dynamic queries, but it is the type conversion that is escaping me.

I'm adapting this solution for custom fields, but the limitation to this solution is you have to know each custom field to make the type conversion.

Here is what I've tried. I got the correct output, except for the type conversions.

Query:

...