Freddie | MailChimp mascot ) is a .NET API wrapper

I have 2 tables in my schemas: employee and dept_emp.

employee table contains all employees' data: emp_no, first_name, last_name, hire_date (when is employee started working for the company). The employee table will some kind looks like this

emp_no first_name last_name hire_date 10001 Liam Nelson 1997-01-02 10002 Freddie Mercury 1998-01-02 10003 Phil Foden 1999-01-02

On another hand, dept_emp table shows in which department every employee works in. One employee can work in > 1 dept in different periods of time. For example, Emp 1 can work on Dept 2 from 01-01-1990 until 31-12-1991 then move on to work in Dept 2 from 01-01-1992. The table consists of emp_no, dept_no, from_date (when that employee started working for that dept), to_date (when that employee started working for that dept). The dept_emp table will some kind looks like this:

emp_no dept_no from_date to_date 10001 0001 1997-01-02 9999-01-02 10002 0002 1998-01-02 1999-03-15 10002 0004 1999-03-16 2001-01-02 10003 0003 1999-01-02 2001-04-08

Based on the table, For all of the employees that are still currently working for the company, The to_date field in the dept_emp table is filled with '9999-01-01' (to show no resignation date yet) whilst for the employee that has resigned The to_date field is filled with their resignation date.

Now for the case, I want to calculate how many days have every employee worked for the company but only for those who already resigned. I figured out that to achieve the result, I would have to subtract the resignation date from the max(to_date) field with the min(from_date). Notice that I give the max function for the to_date because I want the SQL to extract the date which an employee resigned from his last department while I give the min function for the from_date because I want the SQL to extract the date which an employee started in his first department

I have tried the following query:

...

createUserPatch is an API custom command to create a new User.

You can see that I have created a variable "A" inside it.

The variable is used in the body emails part [a]+'freddie.doe@example.com','type': 'work','primary': true}]

I want to find a way to automatically increase the variable "A" whenever I call the command createUserPatch.

...

I'm trying to work on a subclass of arrayList which will sort objects that are of type Comparable in ascending order upon their insertion. The class is generic and implements the Comparable interface too. My problem is that when I attempt to add to the SortedArrayList class like (this.add(item)) I receive an error 'java: incompatible types: E cannot be converted to E', however item is already of type E.

Here is my code:

...

I use Backpack for Laravel 4.1.

Table: users

...

Actually i have 2 fields in my form, Name and Email and when user will hit the submit button this data should store into the mailchimp. but what happen is when i hit the submit button it will redirect me to the mailchimp page and ask to fill the one more Form and the i can subscribe. so i don't want user to fill that one more form on mailchimp page.

Below is my code

...

I would like to check that my field names are uppercase only for fields that meet my preferred definition of "constant", as stated in Google's Java Coding Guidelines.

Thus:

...

Working on code for a school project. I have an div wrapper, article, and aside. The content on my page is mostly in them article/aside, and as a result they extend well past the wrapper and footer. I was suggested a couple of ways to fix this (clearfix::after, .group) but I can't seem to get it. Any way to fix this so the wrapper extends to fit the aside and article?

...

I have a table that looks something like this:

...

I'm trying to use NimbleCSV library for a personal project but I'm having some problems...

...